Digital
www.becomingdigital.com
- Original Message -
From: <[EMAIL PROTECTED]>
To: "Jeff Shapiro" <[EMAIL PROTECTED]>
Cc: "MySQL List" <[EMAIL PROTECTED]>
Sent: Friday, 06 June, 2003 03:18
Subject: Re: establishing a relationship
Yes, a "linking&q
Yes, a "linking" table or a "map" table or a "join" table. "Linking"
is what I see it called in books I have; yes I understand that.
I hope to understand the advice for a third more thoroughly, too. I am
doing this for practice so the theory of what I'm being taught is what
I'm after and afai
Ted,
If in fact you only have a one-to-many relationship, you don't need the
third table (what's also known as a join table in some circles). This
type of table is only really needed if you are doing a many-to-many
(people have 0 to infinity machines, and machines have 0 to infinity
people).
I have a friend teaching me but I want more :-) (second opinions),
please.
A simple Database:
2 tables
a one-to-many relationship
each table has a Primary Key: table1 (one) Primary Key = peopleID;
table2 (many) Primary Key = machinesID
Normally, I would put the peopleID also in table2 as a For