about validation rules

[afnan_88]

hello everybody

i want to have more than one validation rule to my table

how can i do that? (should i sepreate them by "and")

other ques.
how can i write the following expression as a validation rule for my table:

if i enter 1 in field1 then, field2 must be 3 otherwise it must be 1



thanx in advance

 

[PNGBill]

You may not even need a validation rule on your table.

Assuming all data is entered by Form, then you can have the validation on a form.
This will give you better control of the validation as you can have simple validation in the forms text box control or more complex with an event driven vba code.