Managing Groups in a contacts table

[Mervyn Thomas]

I have a "group" table linked to a contacts table so that I can select which
group a contact belongs to.
The question I have is how to put a single contact into many groups? I
have half solved this by having a series of GroupID fields in "Contacts" and
linking each of them to a single GroupID in "Groups" but it's not very
elegant and without multiplieing up the GroupID fields is a bit restricted!
Does anyone have a solution?

 

[KARL DEWEY]

You need three tables - Group, Contact, and junction table Contact_Group.
Set relationship one-to-many from Contact to Contact_Group and also from
Group to Contact_Group.
Use form/subform for data entery and display.