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

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 . . .

See also:

http://fmforums.com/forum/topic/77933-creating-sub-summary-report-with-multiple-layers-of-filters/page__p__365049#entry365049