many to many

[zivtir]

Hi,
I have 3 tables
1.Contacts
2.Groups
3. ContactsGroups (m:m)

I have contact form for editing and addnig the contact table.
the point is that 1 contact can belongs to many group.
maybe someone know how can I implement it on the form?

thanks

[RuralGuy]

Typically we deal with this as two 1:m relationships with one side at a time.

[zivtir]

but if i nevertheless need that

[RuralGuy]

Then you will need to get very creative. That is the best I can supply for advice, sorry.

[kimmer]

Since you already have a Contacts form, add a subform based on ContactsGroups. The subform needs just 1 field... the GroupID field from ContactsGroups. Replace that textbox with a combo box that uses GroupName and GroupID from the Groups table. Display Groupname. Store GroupID.

[A S MANN]

I Had privious solve simmillar problem like ths
Create relationship Contacts Table (1)---(∞)> ContactsGroups (∞)----->(1)Groups
Keep both the fields in ContactsGroups as primary with Key symbol
After ctreating the Many to many relationship
Create a table with Groups Table as raw sourse
Create append query with parameter asking for Group and contact This should add the data of both group and Contacts as asked to append table as ContactsGroups
This will solve your problem Active refresh macro to view details in subform showing fields of ContactsGroups
Hope this will solve your issue