Hi,

I am fairly new to filemaker and to database development in general.

My question is:

I want to create a keyword search script in my database that allows me to match to any word or term in the field. As it is right now (or my current understanding of filemaker) a find function call will match to ALL words or terms in the field.

Can anybody give me advice (i.e., sample code) on creating a search script? I want it to act similarly to the search function on this forum, that is to give users the option to search based on "all" or "any" term placed in the field.

thanks,

Alan

The way FM processes finds, to match ALL words entered, the words are entered into a field in Find mode separated by spaces. To match ANY word of a list, each word must be entered into the field in a separate find request. If the user enters the words into a global text field separated by spaces, you will need to copy them as is to the destination field in find mode for an ALL request and break the words up into separate find requests for an ANY selection.

-bd