Rhino wrote:
The primary key for the intersection table is the COMBINATION of EmpID and
ProjID! Neither column by itself would make sense as the primary key of the
table; the EmpID and ProjID need to be combined to form the primary key. It
is now possible to store as many projects for an employee as you like but no
way to say that Employee 1 is on Project B *twice*. That's exactly what you
want.
This info was just what I needed. Followup question: do I need to somehow tell MySQL that this combination is the primary key?
Kind regards, CK.
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
