Dear list,
So I'm having a bit of trouble with my first schema. I'm sure I'm missing something idiotic here, but days of learning MySQL and setting up servers and working in UNIX have kind of fried my brain. Okay, here goes:
My project management system includes (among others) two tables: "people" and "projects". I want each project to have a list of people that are authorised to view it. To my mind, the field ought to look a bit like this:
--
Authorised list:
Chris Kavanagh
Joe Schmoe
Jane Doe
--But fields can't hold multiple values, can they? And on my schema, it seems to be a many-to-many relationship between the two tables, and I heard that they are the work of the Devil and must be shunned. I'm sure I need to make a new table or something, but I'm not really sure which one. Can anyone help me?
Many thanks in advance, CK.
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
