Does anyone know how to set up multiple validations for a single field?

For instance, I have 3 fields that use the same value list. Once someone selects a name for Field1, I don't want them to select the same name for Field2 without a warning.

I've tried using the "Validated by Calculation" function with the following formula: not Field1 AND not Field3 (this would be for Field2). This validation does not seem to work (ie the validation returns as okay when it should return a validation error).

If I only use one field in the calculation (for example: not Field1), the validation works. However, this doesn't solve my problem.

Any help would be greatly, greatly appreciated.

Thanks!!!

The validation calculation for field2 should be:

(field2 <> field1) and (field2 <> field3)

and similarly for for field1 and field3.

Note: <> is the not equal sign which doesn't display properly here.

[This message has been edited by BobWeaver (edited January 09, 2001).]