linked selections (cascading?)

Support
1

Hi, this is a classical question in databases : for example, metropolitan France has 13 regions, 17 provinces and 96 départements…
How do I set up 3 selection/multiple selection boxes where the choice of a/several region(s) would only open a restricted choice in the next box and then in the third ?
In other words, if I choosed the region “Grand Est” in the first selection box, the provinces box should only show “Alsace, Champagne-Ardenne and Lorraine” - in turn, if I choosed “Alsace” in the provinces box, the départements box should only show “Haut-Rhin and Bas-Rhin”…

Thank you

2

You can try Dynamic Filtering, which would filter the options you can select based on another field.

For example, in the form that stores “provinces”, you can have a “Region” field.

So in the Entry Form:
After you select “Region”, when you select “provinces”, it can be dynamically filtered by “Region” you have already selected.