Preventing Dups for 2 fields

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I think the answer to this is simple, yet it keeps eluding me!

I have two fields in a table DEPARTMENT, and ROLE.

I need to prevent duplicate DEPARTMENT-ROLE entries.

For Example:

Rec DEPT ROLE
1 Payroll Clerk
2 Accounting Clerk <<< ENTRY WOULD BE OK >>
3 Payroll Clerk <<<NEED TO PREVENT THIS ENTRY>>>>

Thanks in advance for any help!
 
One way is to go into table design and add a compound index. Add a new
INDEX and give it a name. On the first row put your "Department" field and
on the second row, put your "ROLE" field and mark it to not allow
duplicates.
 
Perfect. - Thanks Rick!

Rick B said:
One way is to go into table design and add a compound index. Add a new
INDEX and give it a name. On the first row put your "Department" field and
on the second row, put your "ROLE" field and mark it to not allow
duplicates.
Click to expand...
 
Back
Top