AnsweredAssumed Answered

Newbie question

Question asked by StephenLabuda on Jul 1, 2011
Latest reply on Jul 1, 2011 by StephenLabuda


Newbie question


Hello all,

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.

Please advise.

Thanks, Stephen