Ninjapowa Posted January 30, 2009 Share Posted January 30, 2009 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! Link to comment Share on other sites More sharing options...
mr_vodka Posted January 30, 2009 Share Posted January 30, 2009 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. Link to comment Share on other sites More sharing options...
Blake Lucas Posted February 24, 2009 Share Posted February 24, 2009 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 Link to comment Share on other sites More sharing options...
mr_vodka Posted February 24, 2009 Share Posted February 24, 2009 See here. http://fmforums.com/forum/showtopic.php?tid/200873/post/316046 Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 5512 days old. Please don't post here. Open a new topic instead.
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 accountSign in
Already have an account? Sign in here.
Sign In Now