Searching multiple fields for same value without doing lots of repetitive requests
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?