Validation rule for a form

A

Amer

How can I make Access check if two fields are not duplicated?

i.e. one employee file number cannot have the same application number more
than one time.
 
T

TonyT

Hi Amer,

Create an Index on the table with the fields EmployeeID and
ApplicationNumber as a single Index, this will prevent duplicates of BOTH
those items from being saved to the table, but will allow duplicates of any
other combination.

hth,

TonyT..
 
Top