1 Reply Latest reply on Sep 4, 2014 7:22 AM by philmodjunk

    Searching multiple fields for same value without doing lots of repetitive requests

      Title

      Searching multiple fields for same value without doing lots of repetitive requests

      Post

      Hi, I have 10 fields that I do keyword searches in; out of a database of about 50 fields.

      I do the basic keyword search, e.g., "accounting" in the first field, then I repeat with a new find request for the next field etc. Very repetitive and time consuming when I want to search for say first "accounting" then ACCA in all of the 10 fields.

      Is there a way to enter the keyword once, and then tell filemaker to search for this one word in 10 fields that I designate out of the 50 I have?