var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Using one table as a legend for another...
As part of my current project I need to build a number of tables built on groups or services.
My plan is to have one table to act as a legend, if you like;
The idea being that users can then be append to any group within the first table (populated by "SELECT group FROM groups" etc). For example;
ID | GROUP
Is this the most efficient way of achieving this? I dont like having more tables than I really need to, but I cant think of any other ways.
ID | USER | GROUP
1 JOE TEAM1
2 BOB TEAM2
3 TED TEAM3
4 WILL TEAM2
5 ADAM TEAM1
Any advice would be appreciated
That is a classic M:M (Many-to-many) design.
Wait...can a user be in more than one team?