Quartekoen Posted June 26, 2008 Posted June 26, 2008 So, my invoice database is set up so that every invoice has exactly one type. The possible types include Credit, Paid, Charge on Account, etc. Initially, I had it set up so that for searching, the types were listed in a dropdown menu, and that worked great. But looking at it now, the user may want to look at several types at once, so I've changed the dropdown menu into a checkbox set. My problem now is how to search. I know that when multiple values are selected, Filemaker separates each value with a carriage return, but I'm not sure how to do the search with this information. The search should be something like "type1 OR type3 OR type7". Any help would be appreciated. Thanks.
comment Posted June 26, 2008 Posted June 26, 2008 See: http://www.fmforums.com/forum/showtopic.php?tid/175649/ http://www.fmforums.com/forum/showtopic.php?tid/181329/
Quartekoen Posted June 26, 2008 Author Posted June 26, 2008 Wow! I always wondered what the Requests part of New Record/Request was for. I never knew about this and it works wonders. Thanks!
Recommended Posts
This topic is 6328 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