I am brand new to Filemaker and I have a question. I thought it would be easy, but I can't find a clear explanation anywhere by searching the forum, google, etc.
I have setup a very simple database.
One table contains a list of phrases (a lot of them).
The second table contains a list of keywords.
I would like to setup a script / find operation that will search through the phrases table and find any phrases that contain a keyword from the in the keywords table.
I see how I can setup a script to find records if I manual setup the criteria as =*keyword1* and then setup another criteria =*keyword2*, but I can't figure out how to setup the criteria so that it just looks at the keywords table instead of setting up each keyword individually.