Validation rule for a form

  • Thread starter Thread starter Amer
  • Start date Start date
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.
 
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..
 
You must log in or register to reply here.

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

Validation Rule For only one Field 2
How to specify a validation rule with multiple criteria 3
Record Validation??? for newbie 2
Validation rules 2
Validation of a field 3
Validation Rule 1
Validation rules 4
Validation Rule 2

Back
Top