Best practice for multi-field unique key

Tskutnik

Registered User.
Local time
Today, 05:15
Joined
Sep 15, 2012
Messages
234
I have 4 fields in a table that when combined must be unique.
I know you can setup multiple fields as a combined key, but I don't really need these to be the key (I will auto number a unique key). I just need to make sure the same combination of codes is not entered twice.
Do I set this up as multiple key fields anyway?
 
Do I set this up as multiple key fields anyway? yes - does not need to be a primary key
 

Users who are viewing this thread

Back
Top Bottom