Path: news.netfront.net!news.glorb.com!newscon02.news.prodigy.net!prodigy.net!newsdst01.news.prodigy.net!prodigy.com!postmaster.news.prodigy.com!newssvr25.news.prodigy.net.POSTED!88885bfe!not-for-mail From: "Brian Selzer" Newsgroups: comp.databases.ms-access,comp.databases.theory,microsoft.public.access,microsoft.public.access.tablesdbdesign,microsoft.public.sqlserver References: <6kslj.128$J41.113@newssvr14.news.prodigy.net> <_cwnj.926$5K1.500@newssvr12.news.prodigy.net> <13pv4knnn3tdo3d@corp.supernews.com> Subject: Re: Separate PK in Jxn Tbl? Lines: 20 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.3790.2663 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.2757 X-RFC2646: Format=Flowed; Response Message-ID: <72Pnj.1079$R84.359@newssvr25.news.prodigy.net> NNTP-Posting-Host: 68.73.73.118 X-Complaints-To: abuse@prodigy.net X-Trace: newssvr25.news.prodigy.net 1201650947 ST000 68.73.73.118 (Tue, 29 Jan 2008 18:55:47 EST) NNTP-Posting-Date: Tue, 29 Jan 2008 18:55:47 EST Organization: SBC http://yahoo.sbc.com X-UserInfo1: Q[R_PJSCTS@WR_\YBRMNO_TDFZ\@@FXLM@TDOCQDJ@_@FNHBK^RAQFW[ML\THRCKV^GGZKJMGV^^_JSCFFUA_QXFGVSCYRPILH]TRVKC^LSN@DX_HCAFX__@J\DAJBVMY\ZWZCZLPA^MVH_P@\\EOMW\YSXHG__IJQY_@M[A[[AXQ_XDSTAR]\PG]NVAQUVM Date: Tue, 29 Jan 2008 23:55:47 GMT Xref: news.netfront.net comp.databases.ms-access:307602 comp.databases.theory:47352 microsoft.public.access:340038 microsoft.public.access.tablesdbdesign:84425 microsoft.public.sqlserver:7690 "Salad" wrote in message news:13pv4knnn3tdo3d@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.