Lookup Tables

[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

 

[Duane Hookom]

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?