Dear Allen, David, Fred and Keith,

Thanks very much for the responses. Gives me some things to think about.

Alex.


"Tokyo Alex" wrote:

Dear all,

As a relative newbie to the art/science of database design, I was wondering
if there was any consensus view on whether it's better to use an AutoNumber
field as primary key for a table rather than select a (human-understandable)
natural key, assuming one exists that you can guarantee will be unique.
[Snip]