> Table Group
>  id int auto_increment
>  name char
>
> Table Member
>  groupID int auto_increment
>  name char
>
> Table Relationship
>  group_id int
>  member_id int
>

i'd set it up like this

 Table Group
  id int auto_increment
  name char

 Table Member
  userID int auto_increment
  name char
  groupID



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to