Need help defining field validation criteria

[celie]

Hi There,

I am attempting to define a field so that it will not accept a value if it matches either of two other fields. I have tried to calc it in the field settings, I have also tried to insert it in the script that assists in creating new records. My attempt was (≠ "Field A" or "Field B"). The script at least puts up the error message, but it still accepts the value. I'm a little rusty, so if you can assist, please be specific.

Thanks! Celie.

[comment]

Try:

not ( ValidatedField = FieldA or ValidatedField = FieldB )

[celie]

Thank you, this one didn't work either.

[comment]

Didn't work is not a good description. What exactly did you do and what was the result?

Edited February 13, 2008 by Guest

[celie]

Scratch that. I forgot to uncheck "skip data entry validation" in my script. Thank you very much for your assistance!