Posted by toffee on 10/18/06 10:55

correct; but i have groups with 4 sub groups so there are 5 possible columns
for the lookup - at present i have a case switch but thought they might be
some built in features in mysql for that purpose.
Views have been suggested - which am looking into

"Tito" <lrlemieux@gmail.com> wrote in message
news:1161137240.231521.267840@h48g2000cwc.googlegroups.com...
> Isn't the data for the tables are already linked to teams?
>
> If correct, then you won't need to modify any schema.
> You'll just need to modify it's presentation, by triggering the php
> scripts to align the logged in user to the team(s) he/she has access
> to.
>
> You may need to add a new table that links users to teams (if not
> existing already).
>

[Back to original message]