not finding the text it should

[Steven Cappiello]

I have a calculated field which results in text.

The field is a calculation that has the name of a container field in it, to display the contents of the container field in text.

calculated

text field

cont_text = container <-- just the name of the

cont. field in the calculation

so, the cont_text field has the following text values

white.png

yellow.png

red.png

When I try to find on this field, I enter find mode, enter the

text "red.png" in the field, then perform the find,

the result is all the records.. including the records that have yellow.png and white.png in that field.

Could someone explain why that might be ?

I'm on Filemaker 8.

cheers,

Steven

[Steven Cappiello]

as a follow-up to this..

if I find for "red" or "red.png"

it pulls up all records that have "red.png" or "yellow.png" in that field

if I find for "yellow.png" or "yellow"

it finds no records