[AccessD] OT: The Great Primary Debate

Gustav,

Aww... I'm not being sensitive... just my lame attempt at self-deprecating
humor :-) I don't have the talent for sparking flame-fests that some others
in this group do...

I agree -- the Autonumber PK is the normal choice, paired with a business or
natural key.

Things would be so much simpler on Planet Marklar. On Marklar (familiar to
viewers of South Park), all people and things are named 'Marklar'. This
causes no confusion for Marklarians, who can easily distinguish between any
two Marklars.

I suppose, in Marklarian relational theory, all tables would share a single
primary key value: 'Marklar', and have one attribute: 'Marklar'. That would
make data-modeling on Marklar either the easiest or most-insanity inducing
job imaginable.

-Ken

On Wed Jun 9 at 02:35, Gustav Brock wrote:

>Ahh, Ken, not so sensitive - at least you didn't get flamed,
>and - for what credit it is worth - I didn't delete your message
>on "Using Modified Julian Days" - it is there should I need it.
>However, I'm not doing any data warehousing and have never felt
>the need for date tables, though I can see the possible
>advantages of those for some scenarios.

>Having said that, I'm convinced that using anything else than
>a meaningless PK should be reserved for very special cases.