Dropdown list filter

Ask the community
,
1

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?

2

You should look at this

3

Thanks Andreas for sharing the link, but I would also like to know how to create a dependent drop down list that filters a single database by country, state, city, and area. I don’t have anything knowledge in coding, a detailed answer would be more helpful…