Re: Separate PK in Jxn Tbl?

From: David Cressey <>
Date: Wed, 23 Jan 2008 21:41:54 GMT
Message-ID: <CwOlj.3951$uB6.2631_at_trndny05>

"Tony Toews [MVP]" <> wrote in message
> "Neil" <> wrote:
> >However, I just came across some code in which the person created a
> >table with a separate PK consisting of an autonumber field, and then the
> >fields.
> >
> >So I was wondering how others did junction tables -- with a standalone
> >autonumber PK, or with a PK consisting of the PKs of the tables being
> >joined? And, if a standalone PK, then why?
> I always use an autonumber PK and a uniqui index set on the two FK fields.
> Why? No particular good reason. One of my database rules is that all
tables have
> an autonumber primary key. It's also slightly easier to delete the
record in code.
> Now if I was to have a child table from the junction table then I would
> use a autonumber primary key for ease of use when designing queries, forms
> reports.
> The theorists will argue. I don't care.

Sometimes, theory IS practical. (Some would say always). A pragmatic person would at least listen to the arguments of theorists before dismissing them. Received on Wed Jan 23 2008 - 22:41:54 CET

Original text of this message