Wickerman Posted May 9, 2011 Posted May 9, 2011 I have a portal on a layout displaying 10 repetitions of "Keywords" that the user can enter to tag Artwork records with descriptive terms. The user can search by entering Find mode, but in Find mode there is only one repetition available, so it seems to me that it is not possible to perform a logical "AND" search -- say Find artworks tagged as "Landscape" AND "Cubist" (the way I might find "Landscape" AND "1929" where the year is held in a separate Year field. I looked in the FMP Knowledge Base to see if I was missing something, and found this: http://help.filemaker.com/app/answers/detail/a_id/3183/kw/search%20in%20portal . . . which seems to answer my exact question, but I'm puzzled because the title of the article says it applies to "OR" searches -- which it seems to me is simply achieved by entering "Landscape" and then clicking "New Request" as many times as you like. Is this a simple error in the title -- should the title have "AND" instead of "OR"? Finally, the advice given there was pretty much what I expected -- "no can do," so create a nearly identical layout for Find mode with repeating search fields instead of the portal. But I see this article is referenced for early versions of FMP -- is there a way to do this more easily now, directly on the original data entry layout? Thanks
Wickerman Posted May 9, 2011 Author Posted May 9, 2011 I just remembered about the "Constrain Found Set" feature , which seems to be the best solution here -- a little user training goes a long way . . .
comment Posted May 9, 2011 Posted May 9, 2011 See also: http://fmforums.com/forum/topic/77933-creating-sub-summary-report-with-multiple-layers-of-filters/page__p__365049#entry365049
Recommended Posts
This topic is 4946 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