August 29th, 2013, 11:35 AM
Assign users to multiple groups
I have a table of users and a table of relatives, currently a user can only be assigned to one relative, with that relatives id being stored in the user table under the column name relativeid.
I want to be able to assign multiple relatives to a single user but im not sure how i would achieve this. I could add a second relativeid column for the users, with null values if no second relative exists but (although unlikely in this system) there could potentially be 3 maybe 4 relatives. I thought their must be a more efficient way of doing this?
August 29th, 2013, 11:44 AM
August 29th, 2013, 12:39 PM
Thanks i will look into this.