Hello!

I have multiple records with a aTriage field that contains True/False

In another table I want to have a drop down list that only shows the records where the aTriage is True.

any ideas?

thanks!

You need to create a relationship so that it filters for those that are TRue.

Either create a unstored calc or global with the string "True" or you can change your process so that instead of using a True / False, you can use a checkbox with a value or 1. Then you can relate it to an unstored calc of 1 ( on the parent side).

Whichever way you choose you can then create a new value list based off that new filter relationship.

Building on that question. I am doing similar, but instead of True/false, i am doing a search for a list of customers in a certain state, and those that match go in a portal list.

My list i keep gettign all my customers. I dont think I can use the global field filter in this case. How can I get only the found set of customer to show in the list?

Blake

See here.

http://fmforums.com/forum/showtopic.php?tid/200873/post/316046