[AccessD] OT: The Great Primary Debate

Hi Jim

> Lambert: Your are right of course...always keep the client happy and in this
> case what they do not will not hurt you.

Except that you will be denormalizing your schema!

/gustav


> Ah Hah! This sounds  like a cunning variation on "show them what the want to
> see, but use an AutoNumber in any case".

> I like it!  :-)

> Lambert

>> -----Original Message-----
>> From: Porter, Mark [SMTP:MPorter at acsalaska.com]
>> Sent: Wednesday, June 02, 2004 5:04 PM
>> To:   Access Developers discussion and problem solving
>> Subject:      RE: [AccessD] OT: The Great Primary Debate
>>
>> One approach I've seen which I've adopted is a combination of both.
>>
>> Each table has both a unique identifier as well as a natural key.  The
>> unique identifier is always the FK and has the clustered index.  Great for
>> joins and row identifiers.
>>
>> The natural key has a unique index on the fields preventing duplicates.