If field one matches field two...

[ibiubu]

If I have a field that contains text, seperated by paragraph returns such as:

Apple

Orange

Banana

Pineapple

Cherry

And I have another empty tect field...

Is there a calculation that can be used that if I type any of the words contained in the first field, the calculation would return a positive value. For example, if I type "Orange" in the second text field, the calculation sees that the first field contains the matching word "Orange" and so the calculation returns a value of "Yes"

Larry

[BobWeaver]

Case(Position(FirstField,SecondField,1,1),"Yes","No")

[BobWeaver]

Actually, it's better to use this:

Case(Position("

[Ugo DI LUCA]

Hi,

Could also be done through a relationship from field 2 to field 1 within the same record and an autoentered calc.

Oops. FM6 post, so a strict unstored calc wouldn't be as helpfull that the one Bob suggested...