Prev: Design theory for maintaining historical address communication
Next: Lookup fields referring to tbls w/o relationship
From: Tokyo Alex on 8 Jan 2010 04:03 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]
From: Fred on 8 Jan 2010 11:22
I'd say the same thing. I should have clarified that post was actually just about the "everything else" cases. |