Multi Level Value Lists
What is the best way to construct multilevel Value Lists where more than two levels are involved? I want to do something like the following:
- Pop up Menu to select from a list of Countries
- Pop up Menu to select from a list of Regions. List limited to Country selected in last step.
- Pop up Menu to select from a list of Cities. List limited to Regions selected in last step.
The City selected will be stored as an attribute of a record in a related table. Basically, what I'm trying to do is make it easier for the user to narrow into the correct City and avoid them having to select from the entire list of worldwide cities.
I've tried several ways to get this to work but am just not getting it right. As usual, I suspect I'm missing something obvious. I would appreciate any guidance.