Validation Rule

[RayHuss]

In Access 2003 how do I set up this databse rule? If Field A equals the
value "West", then Field B can only equal the values "Sam" Or "Bob".

 

[Allen Browne]

Open your table in design view.
Open the Properties box (View menu).
Beside the Validation Rule for the table, try:
([A] Is Null) OR ([A] <> "West") OR ( IN ("Sam", "Bob"))

The rule is satisfied if A is blank or something other than West.
Otherwise the only way it can be satisifed is if B is one of the value
listed.

Note that the table's rule (in the Proprties box) is not the same as a
field's Validation Rule (in the lower pane of table design.)