Help with a calculation

[Carri]

I have a field in a table that displays the following type of entry in one field (entries varies), this info is referenced from another table:

Equipment

Logistics

Speaker

Location

I'm trying to create a new field in the same table that will display "Yes" if Equipment is one of the entries in the list.

Can anyone please help me, Thanks

[Søren Dyhr]

You could of course use this:

http://www.filemaker.com/help/FunctionsRef-370.html

But if you need to test for several values, say both Equipment and Speaker, offers this calc' a tiny bit more flexibility:

LeftWords("yes";ValueCount ( FilterValues ( Values ; "Equipment" )))

Because it swiftly could be changed to deal with it this way:

LeftWords("yes";ValueCount ( FilterValues ( Values ; "Equipment¶Speaker" )))

Since the origin of the data probably is from a checkbox'ed field where no-one can predict the order each value is entered.

--sd

[Carri]

Thank you so much worked perfectly.

I'm new to the Forum thing and it's so great how everyone is so willing to much.

Very Appreciative

C