Home      FAQ      Forum      Idea Exchange      Ask a Question      My Stuff      Help   
  
Cascading Dropdowns
Question
ID
37
Category
TeamDesk
Date Created
3/27/2010 4:26:29 PM
Date Updated
3/27/2010 4:28:22 PM
How do I restrict the list of choices in one table based on user selection in another
Answer
Suppose there is a Countries table and a Cities table - the City refers to Country.

If you are implementing Addresses table, obviously it is enough to have a relation to the City - the Country could be looked up from Cities table.

However if you want the user to select Country first and then the City from the country-restricted list you should first add a relation from Addresses to a Country - this will render Countries as a dropdown - and add match condition to the Address-City relationship to match City.Country and Address.Country.
Related articles
Was this information helpful?
 
Back to Search Results