Related drop-down lists
FM Pro 11; Mac OS Snow Leopard
I would like to make a set of related drop-down lists for address entries. I would like to be able to select a [COMMUNITY] in one field from a drop down list of towns in the area, and then have it provide another drop down list of [POSTAL CODES] for that specific community.
How do I relate the two?? I thought of having a separate value list for each community but I'm still not sure how to connect the dots....
You are describing what we filemaker geeks call a "conditional value list".
Here's a thread on setting up conditional value lists:
Custom Value List?
You'll need some kind of "community" table so that you can define a relationship like this for your postal codes drop down:
Community::CommunityID = PostalCodes::CommunityID
PostalCodes::CityID = Cities::CityID