Validation

[brum_rich]

I have two tables that are linked by a common ID

tblRole contains a field called Vacancy which is set up as a Check Box (yes/no data type)

tblEmployee contains a field for Surname.

I would like to set some validation to stop the values in these fields being populated at the same time. For example if checkbox in tblRole is ticked Surname must be blank and likewise if Surname is populated then the Vacancy field must be unchecked.

Any ideas how I might go about this?

 

[brum_rich]

Do not have any forms yet - is there anyway that I can enter this validation against the fielld(s) or table?