View Single Post
  #2  
Old August 2nd, 2007, 10:56 PM posted to microsoft.public.access.tablesdbdesign
mray29
external usenet poster
 
Posts: 61
Default PK - To AutoNumber or Not To AutoNumber - That is the Question! :-

Dee:
If your employee numbers are unique, there's no reason to add another
autonumer PK. Just make the employee numer your primary key for the table and
you'll be fine.

"dee" wrote:

Seriously... if I have, for example, employee numbers in an Employees table,
should I use the employee number (will never change) or should I add an
autonumber PK?
--
Thanks!

Dee