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

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

×
×
  • Create New...

Important Information

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