Requires Linked SingleSelect/MultiSelect Dropdown, which can be restricted on the basis of any criteria. In particular I need Dropdowns, which offer a subset of choices based on the result of another dropdown/field.
For example, I would like to have a drop-down “LAND”, which gets the data from a separate table (LAND, REGION).
The table would then look like this:
COUNTRY, REGION
Switzerland, Aarau
Switzerland, Bern
Switzerland, Zurich
Germany, Baden-Württemberg
Germany, Lower Saxony
Germany, Saarland
France, Aquitaine
France, Brittany
France, Poitou-Charentes
…, …
A second dropdown “REGION” should then only show the regions matching the selected country.
Then the second dropdown should only show “Aquitaine”, “Bretage” and “Poitou-Charentes” when I select “France” as the LAND.
If I look up in the forums, this is probably a very popular wish for a long time. Is something like this available now and if so, how does it work?