Jump to content
Sign in to follow this  
Ninjapowa

show only found records in list

Recommended Posts

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!

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

See here.

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

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×

Important Information

By using this site, you agree to our Terms of Use.