Related Value List

[Tom Kennedy]

How do I create what I call a related value list? An example would be: You have a "State" value list and a "City" related value list. When you choose a "State" you want the "City" choices to include only the cities for that state.

[Inky Phil]

Hello Tom

do a search for 'conditional' value list. You should get at least a bazillion results :-)

Phil

[Tom Kennedy]

I have searched on the "conditional" term instead of my "related" term and have not found a good example yet. Is there good .fp7 example that doesn't use custom values and uses tables with ID's and descriptions?

[aldipalo]

Comment helped me put this together. Hope it fits your needs. It's City, State, Zip, but, if you play around with it you'll get it the way you want it.

Al

ZipCode_Test.zip

[Tom Kennedy]

I apologize for not being able to follow the example in light of my situation. I have prepared a FileMaker file (which is attached) that has 3 tables: Contact, State and City. In addition, 3 corresponding layouts and 2 Value Lists (one for State and 1 for City) are also included. In the Contacts layout, the StateID and the CityID are dropdowns. The StateID works as planned. The modification I need is to the CityID - it should show only the cities for the StateID (entered previously).

Any help will be appreciated.

CityStateConditionalValueList.fp7.zip

[comment]

Try it this way (attached).

Note that your ID system is not exactly ideal - you should use auto-entered serial numbers at least for the cities (with the states you could wing it by using a two-letter abbreviation, but it should be validated as unique).

CityStateConditionalValueList2.fp7.zip