8 Replies Latest reply on May 8, 2012 1:57 PM by MegKennedy

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

    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