Re: Separate PK in Jxn Tbl?

From: David Cressey <cressey73_at_verizon.net>
Date: Tue, 22 Jan 2008 21:23:48 GMT
Message-ID: <E9tlj.8567$YH6.8564_at_trndny03>


"Neil" <nospam_at_nospam.net> wrote in message news:6kslj.128$J41.113_at_newssvr14.news.prodigy.net...

> 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?

With a PK consisting of the FKs that reference the tables being joined.

Is that what you meant? Received on Tue Jan 22 2008 - 22:23:48 CET

Original text of this message