look up tables

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

JL - 07 Jul 2006 20:21 GMT

When using a lookup table with only one field, is it necessary to add
an additional field to be the primary key, or can the field itself be
the primary key? For example, for a list of state abbreviations where
they are never the same, could the Field with the abbreviation be the
primary key?

Thanks,
JL

Reply to this Message

Rick Brandt - 07 Jul 2006 21:04 GMT

> When using a lookup table with only one field, is it necessary to add
> an additional field to be the primary key, or can the field itself be
[quoted text clipped - 4 lines]
> Thanks,
> JL

Sure. If the single field is unique and stable then I see no point in
having a surrogate key field. Others use them all the time no matter what.
It's kind of a personal preference issue.

Signature

Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

Reply to this Message