I am new to REI3 (and database programming in general) and trying to figure out the most efficient way to do certain things. Here is my situation using example information:
I have 3 relations. Continents, Countries, States/Provinces. Each is filled with ALL records of that type. On the form, when I click on Continents, I get the full list of Continents to select. That is a reasonable sized list. But when we get to States/Provinces, the list is very long because it contains every option from the whole world.
I have experimented with Form States, and have been successful using filters on the list of Countries so that they only show the Countries from the selected Continent. But I think I would need to place multiple copies of the Country field into the form, with the appropriate Continent filter for each continent. I would hide the Country fields of all the NOT-selected Continents, and only display the Country field for the selected Continent.
While this isn't too difficult at the Country level, it becomes very big if I have to provide State/Province fields for every Country. I'm hoping there is a more efficient way to do this. It seems I need dynamic filters that adjust based on previously selected values.
To clarify, I would like the most efficient way to setup a form so that when I select Continent: Europe, Country: Germany, and then click on State/Province, I am only presented with the 16 states of Germany.
Thanks for any suggestions on how to do this!
