Re: Separate PK in Jxn Tbl?
Date: Wed, 23 Jan 2008 21:41:54 GMT
"Tony Toews [MVP]" <ttoews_at_telusplanet.net> wrote in message
> "Neil" <nospam_at_nospam.net> 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
> >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
> 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
> 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