Values List question

[stan111]

Gentlemen,

I have two value lists: Category and Subcategory.

Category contains the following: Food, Drinks. Subcategory contains: Chips, Soda, Juice. 

How can I do the following thing: when choosing Food, I want Chips field only be available for selection (no drinks displayed).  And vise versa.

 

Thanks!

 

[Steve Martino]

You will need to search for 'Conditional Value List' or 'Dwindling Value List' on the forums.  There are many easy examples to emulate samples.

Edited December 11, 2018 by Steve Martino

[stan111]

Thanks! But I wasn't able to find a solution! The question is still open. 

Thanks everybody!

Edited December 11, 2018 by stan111

[comment]

Try this tutorial first:
https://support.filemaker.com/s/article/Creating-conditional-Value-Lists-1503692929150?language=en_US

Then perhaps these demos might be useful:
https://fmforums.com/topic/55459-automatic-zipcode-data-entry-help/?do=findComment&comment=261760
https://fmforums.com/topic/81562-to-number-subgroups/?do=findComment&comment=378671
https://fmforums.com/topic/81562-to-number-subgroups/?do=findComment&comment=378937
https://fmforums.com/topic/90967-conditional-value-list-based-on-multiple-tables/?do=findComment&comment=417716

 

 

[stan111]

Bravo! It works like a charm!