Preventing Dups for 2 fields

P

PK

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!
 

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

Top