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 Foreign key to establish the relationship and be done with it.
I am being taught now to create a third table, table3, and in it have 2 columns; those being the peopleID and machinesID (the Primary keys from the other 2 tables). This is apparently a good idea when it comes to deleting or updating records. (?)
My question is, how is the relationship between table1 and table2 established using this method?
I hope you understand my question. If I try to explain further it will only become convoluted, possibly more than it is!
Thanks, Ted Rogers
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
