Validating Text field on Form against another field in same record.

scorpio125

New member
Local time
Today, 14:25
Joined
Apr 17, 2014
Messages
8
Sorry if this has been discussed already, i'm not even sure I have the right terminology down yet.

I have a form where I would like to validate (restrict) choices in subsequent fields.

Example

Combobox choices are Air, Fire, Water, Earth, Space

In the form I have 4 fields = Material1, Material2, Material3, Material4. (all in same record on my table)

Basically I need the validation to not allow duplicates across the 4 fields.

something like....

[Material1] <> [Material2] or [Material3]or [Material4]

I am not sure of the proper syntax for the validation field in the Form Properties. Or if I am even putting it in the right place.

Any help would be great.

~George
 
Tell us more about Material1, Material2, Material3, Material4. Tell us about the underlying table.
 
Basically it is a list of materials to be used on a job site at different stages. The materials are restricted to the list from my lookup table.

There are 4 materials that can be chosen for each stage of the job but cannot repeat.

LKUP Material Type Table
Earth
Fire
Water
Air
Space

The form needs to ask which four are being chosen and the user enters corresponding weights to be used. So there are 4 corresponding combo boxes.

So when I ask for [material1] it cannot be already selected in [Material2] or [Material3] or [Material4] the user choose for each material but cannot repeat what was already selected.

For example if Water was chosen in [Material1] it cannot be chosen or added to the table in [Materials 2 thru 4]

Then the row is as such

Job Material1 Wght1 Material2 Wght2 Material3 Wght3 Material4 Wght4
 

Users who are viewing this thread

Back
Top Bottom