On Thu, 2 Aug 2007 14:36:01 -0700, dee wrote:

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?

A primary key candidate should meet three criteria: it should be unique within
the table; it should (preferably) be stable, not something that will get
edited after entry; and (ideally) it should be reasonably small (8 bytes is
the size of an Autonumber so that's a benchmark).

If your employee number meets those criteria it's a good "natural key" and you
should by all means use it.

John W. Vinson [MVP]