AnsweredAssumed Answered

How to multi-search within the same field using "AND."

Question asked by MegKennedy on May 8, 2012
Latest reply on May 8, 2012 by MegKennedy

Title

How to multi-search within the same field using "AND."

Post

I'm trying to generate a multiple find search in a single field, but I only want "AND" results. Our database has a field entitled "Keywords." The records in our database are "tagged" with all applicable keywords, from a single keyword to dozens. There are several hundred of these keywords and I'd like to generate results that bring back records with, ideally, two of these keywords. For example, I'd like to find all records that are "tagged" with the keyword "Architecture" AND "Outbuildings." I can only figure out how to search for "Architecture" OR "Outbuildings" which generates more results than I need.

Thanks in advance!

 

filemaker.jpg

Outcomes