View Single Post
  #3  
Old August 2nd, 2007, 11:43 PM posted to microsoft.public.access.tablesdbdesign
Jeff Boyce
external usenet poster
 
Posts: 8,621
Default PK - To AutoNumber or Not To AutoNumber - That is the Question! :-

The only thing an Access Autonumber is designed to do is provide a unique
record/row identifier. If you already have one, why bother with another?!

Regards

Jeff Boyce
Microsoft Office/Access MVP

"dee" wrote in message
...
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