Validation not equal to value list?

[Tyra]

What is the easist way to validate a field by makeing sure it is not in a value list.

I have a field "Fruit" and need to make sure that the entered value is not in my value list "Forbidden Fruit"

I tried to use validate by calculation, some thing like "Fruit" ≠ "Forbidden Fruit" but cant figure out how to use a value list in a calculation field.

[Raybaudi]

Hi

what about:

ValueCount ( FilterValues ( ValueListItems ( Get ( FileName ) ; "Forbidden Fruit" ) ; Fruit ) ) = 0

[Tyra]

Daniele,

That seems to work just fine.. thank you very much, it also explained how to call a value list for calculation.

Ty