|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
February 11th, 2009, 04:40 PM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
Managing Groups in a contacts table
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? 
|
|
#2
February 11th, 2009, 05:17 PM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
Managing Groups in a contacts table
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. -- KARL DEWEY Build a little - Test a little "Mervyn Thomas" wrote: 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?
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
