Jump to content

Help! Validating Fields


This topic is 8537 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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!!!

Link to comment
Share on other sites

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).]

Link to comment
Share on other sites

This topic is 8537 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.