Re: Normalising a two-to-one relationship
From: Thomas Baker <ohnoyoudont_at_nodomainherejkls.com>
Date: Tue, 2 Jan 2001 10:44:19 -0000
Message-ID: <92sbjo$jkb$1_at_uranium.btinternet.com>
Date: Tue, 2 Jan 2001 10:44:19 -0000
Message-ID: <92sbjo$jkb$1_at_uranium.btinternet.com>
Of course! I thought of that but dismissed it because I thought there would be duplicates but there can't be. Doh!
Thanks for your help.
T
"David Cressey" <david_at_dcressey.com> wrote in message
news:wTP36.383$2X4.33007_at_petpeeve.ziplink.net...
> If I were doing it, I would make the primary key of the fixture_teams
> table be a compound key, consisting of the two foreign keys.
>
> Thomas Baker wrote in message <92nh64$gdk$1_at_uranium.btinternet.com>...
> >So if I stick with two tables what do I do about the primary key in the
> >second table (fixtures_teams)?
>
>
>
Received on Tue Jan 02 2001 - 11:44:19 CET