[AccessD] Surrogates vs Natural

artful at rogers.com artful at rogers.com
Thu Dec 28 17:59:19 CST 2006


AFAIK there is no such thing as a multi-column surrogate key. If I'm wrong, it wouldn't be the first time, but the concept itself makes me dizzy.

----- Original Message ----
From: Stuart McLachlan <stuart at lexacorp.com.pg>
To: Access Developers discussion and problem solving <accessd at databaseadvisors.com>
Sent: Thursday, December 28, 2006 5:34:34 PM
Subject: Re: [AccessD] Surrogates vs Natural

?multifield surrogate keys?

I presume you mean "natural".
I can't think of any reason to have a multifield surrogate.

On 28 Dec 2006 at 14:22, Charlotte Foust wrote:

> Yeah, well try working with multi-table joins on multifield surrogate
> keys and see how handy it is! :o<

-- 
Stuart


-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com







More information about the AccessD mailing list