Re: Separate PK in Jxn Tbl?
From: Brian Selzer <brian_at_selzer-software.com>
Date: Tue, 29 Jan 2008 23:55:47 GMT
Message-ID: <72Pnj.1079$R84.359_at_newssvr25.news.prodigy.net>
Date: Tue, 29 Jan 2008 23:55:47 GMT
Message-ID: <72Pnj.1079$R84.359_at_newssvr25.news.prodigy.net>
"Salad" <oil_at_vinegar.com> wrote in message
news:13pv4knnn3tdo3d_at_corp.supernews.com...
> Sylvain Lafontaine wrote:
>>>I concede the point that for the two keys of the junction table, using an
>>>autonumber primary key is overkill except for special situations.
>>
>>
>> Shouldn't a database be designed right from the beginning?
>>
> I prefer KISS.
>
> Thus I prefer an autonumber.
>
> Then again, junction tables are rarely needed.
Simple is as Simple does. Received on Wed Jan 30 2008 - 00:55:47 CET