I need to create a database filter, only with dropdown button list ( 4 Nos ). I have business centres in various location, i need to filter them by country, state, city, and area. Like all the dropdown list depend on the previous selection.
The single database contains all the address of my locations, and i don't want the same country to repeat in the dropdown list button again ( same for state, city and area ) and when the submit button is clicked, the relevant address is to be visible.
Is there any way to achieve this kind of result?