How To Place Conditional Values in Value List?

[bdavid]

Working on my first FMP project : and I want to create a dropdown list that will only show the appropriate choices for companies in a given state. The state is part of a table of people that you will search for by name, address, reference #, etc. I want to filter the dropdown list to only show companies that operate in the state where the people are.

What is the most efficient way to do the filtering? Should I just populate another table by triggering a script that will do the appropriate find and then populate the value list from there?

New to this ...thanks in advance for your advice!

[mr_vodka]

do an advanced search on these forums for +conditional +valuelist and you should see lots of examples.

[bdavid]

Thanks for the pointer Mr. V -