using calc fields to match keywords

[bizpal]

Would a calculation field be the route to go with the following?

Is it possible in FileMaker Pro to check every word in a text field in one database against single-word entries (records) in another database and identify matches?

All words in the original text field that matched would ideally be highlighted or bolded to indicate match.

Additonally, I would like to link from each highlighted word to corresponding fields in another database.

Thanks.

Gordon

[Vaughan]

Use the PatternCount() function to identify matches.

Highlighting matched words is another issue: it can be done but is quite kludgy. think there are some demos around... I'll leave it to others to post their urls.

[bizpal]

Thanks, Vaughan. I appreciate any help I can get.

Gordon