I'm trying to get a field to look up multiple matches to find a name, but FM only looks it up successfully if there's a single name.

I have a database of news articles.

Another database contains employee names and other info, including a field that has a brief "summary" description of that person.

My goal is to look up the article text (a field called "story") to see if an employee is named in the text. If so, a calculated "people" field should get the name from the employee database and add the short description behind it.

I can get the relationships to work when I type a single name into the match field, but not when more than one name is typed in.

In addition, I can't figure out how to get the calculation script to find a person's name inside the long story text. There doesn't appear to be a formula that finds a simple word match inside another field.

So I guess there are two problems to solve. But I can live with having people manually type the list of names from each story if necessary to create the lookup.

Can anyone help? Thanks

------------------

= George Pytlik =

[email protected]

The reason this doesn't work has to do with the way filemaker indexes. Each word of text separated by a breaking space (not option-space) is indexed separately. A seach for John Jones finds all occurrences of "John", "Jones" and "John Jones".

As to a function, create a global text field called gSearch and create a field TextFound? = PatternCount(ArticleText, gSearch), result is number. Set gSearch to the desired search string and performa a find for TextFound? >0.

-bd