I would like to narrow down my search using lookup tables.
For example I have a table that lists ten provinces in the country.
I want to view the different districts in the different provinces and the
different hospitals in the different districts in a registration form.
How can i achieve this cascading effect so that when a user selects a
specific district only the hospitals that are found in that district are
listed for selection by the user.
How do i define the relationship between lookup tables to enable cascading and
narrowing down searches according to a specific field.
I would like to narrow down my search using lookup tables.
For example I have a table that lists ten provinces in the country.
I want to view the different districts in the different provinces and the
different hospitals in the different districts in a registration form.
How can i achieve this cascading effect so that when a user selects a
specific district only the hospitals that are found in that district are
listed for selection by the user.
How do i define the relationship between lookup tables to enable cascading and
narrowing down searches according to a specific field.