Lookup Tables

  • Thread starter Thread starter Steve
  • Start date Start date
S

Steve

When creating lookup tables with just one field is it a good idea to create
another field and make it an autonumber field and primary key. I mean if I
have a table that only has a few items do I need it. Wouldn't it be good to
just make the lookup field itself the primary key? Seems like it would keep
you from having duplicates also?

TIA
Steve
 
This simple question is a source of much debate. If the values won't ever
change, I might think it's ok to create just the one field and use it as the
primary key. How's that for an almost definitive answer?
 
Back
Top