look up tables

  • Thread starter Thread starter JL
  • Start date Start date
J

JL

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
 
JL said:
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
Click to expand...

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.
 
Back
Top