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

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

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