Interested in allwoing users to generate there own user groups, as many as they would like, so they can choose predetermined product codes to assign to each group. Quantity of groups and codes would vary from user to user.

Any ideas on the structure of tables for someting like this?

Thanks,
JoshC

in other words,
User1
user1_Group1, user1_Group2, user1_Group3

Prod1 and Prod3 to user1_Group1
Prod56 and Prod78 to user1_Group2
Prod45 and Prod67 to user1_Group3

where only certain product numbers are available to different users.


I'm just having trouble wrapping my head around the table structure.
Thx.