I am trying to do a find where I am searching through keywords in my db.

I want to find any record that has at least one of these keywords in them:

doll

barbie

marie osmond

but not these words

dollar

dolly

I cannot figure this out from my filemaker books.

Any tips on this would help *

Thank you for taking a look

Okay I understand now that I can use

=doll

& then do another find & constraining or extending the found set, but just wondering if there is a syntax that can be entered in one find field that will end up with the same final result set?

Edited November 27, 200619 yr by Guest

There is no way to do an generic "or" find using a single field, you must use multiple find requests.