1 Reply Latest reply on Jun 21, 2010 10:55 AM by philmodjunk

    Related drop-down lists



      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....











        • 1. Re: Related drop-down lists

          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