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

    Related drop-down lists

    FMNewbie

      Title

      Related drop-down lists

      Post

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

       

      Help?

       

       

       

       

       

       

       

       

        • 1. Re: Related drop-down lists
          philmodjunk

          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