Hello all, I have been wondering if this is even possible:
Say,
a) I have a database containing real estate licensees ("members") and their real estate listings;
members can form groups and each group will have a unique group name ("team1", "team2", etc);
c) listings of a members that are linked to a particular group name of that member can be displayed in the website of other members of the group (e.g., listings that are linked to the group name "team1" of all members of the group can be retrieved by any member in the group using the "team1" group name); and
d) I store the group names in the column "group_name" in table "members".
Now my problem is, say if a member belongs to two groups ("team1", "team8"),
1) can I store both "team1" and "team8" in the "group_name" field under that member?
2) how could his listings be retrieved and displayed in different group members' sites by either of these group names?
My goal is to allow members to have more than one group name, and his /her listings will be retrieved by different group members quoting the appropriate group names. How could I achieve this?
Thanks,
Cofa