DATA VALIDATION RULE BASED VARIED ENTRIES IN ANOTHER FIELD

H

hikerbiker

I am trying to create a validation rule for a table that will limit entries
based on values entered in another field of the same table. For example: if
my material field says "plastics", then my color field should only allow
"blue" or "red". If it says "steel", then it should only allow "red" or
"green". It appears that I can only limit the values in the color field to
be anything that might be valid for all materials.
 
B

Beetle

I don't think you'll be able to do that with a validation rule.

If you only have a few possible combinations it could be done
with some simple VBA code behind a form. If you have many possibilites
it may be better to create a lookup table related 1:m to the materials
table and use a combo box on a form to limit the choices based
on which material was entered.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Validation rule of 1 field based on a field of another table 1
validation rule for unique number 5
Validation rule for duplicate address entries 5
Requiring data in one field based on another field's contents... 2
Validation Question 4
Validation Rule in Access 2007 3
Validation based on another fields value 4
Validation Rule 3

Top