Preventing Dups for 2 fields

[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!

 

[Rick B]

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.

 

[Guest]

Perfect. - Thanks Rick!

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.