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