Hi there,

I am fairly new to website design and db development and I have set up a user database with contact details all in one table (for ease)...

Now I would like these users to be able to attach themselves to one or more groups and I am not sure of the best approach to take?

I was thinking of having one tables for ids and names of groups and then another table with the foreign keys user id and group id. Would appreciate any views on this.

Many Thanks

Hick

Yep that's the right way to go.

Thanks for the reassurance chris. I would like to try a private messaging system eventually too...

Would I take a similar approach i.e. have a table called mailboxes which has the a row with the id of the users and rows for each messages sent to them?

This would limit the amount of messages you could have tho wouldn't it as you could only have as many as the amount of colums you set in the table?

Would it be better to just have all messages stored as one individual row and group them by the id - so although there not physically stored together when you request them as a group they are???

Thanks again

Hick Man