Managing Groups in a contacts table

  • Thread starter Thread starter Mervyn Thomas
  • Start date Start date
M

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?
 
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.
 
Back
Top