Coding a many to many database relationship

  • Thread starter Thread starter BBM
  • Start date Start date
B

BBM

Does anyone know where to find an explanation / discussion
of implementing a many to many database relationship with
Access - particulary with respect to inputting /
displaying the many to many relationship?
 
Many-to-many in a relational database requires three tables ... the two
"many" side tables, plus the relation/resolver table used to show valid
one-to-one combinations.

One approach to handling this in a form is to use a combo box to look up one
of the "many" values from table1, and a second combo to look up a valid
"many" from table2. The form is based on the resolver table, and holds
records consisting of matched pairs (i.e., the valid combinations).
 
Jeff,

Thanks for your response. My problem is that I don't have
two existing table values. I'm creating one side of the
many to many relationship "on the fly". See my post "Many
to many with bound forms" post from May 15th for a
complete explanation of what I'm trying to accomplish.

I was hoping someone could refer me to a KB article or a
book that does a really exhaustive treatment of this topic.

Thanks again.
 
Hi BBM,

I noticed that another post of you titled "Cancel Database Update on a
Bound Form" discussing the same topic as this one. I have added my reply to
that post, if you have follow up questions, would you please add your reply
to that post? I will be glad to work with you :)

Thank you for your patience and cooperation. If you have any questions or
concerns, don't hesitate to let me know. We are here to be of assistance!

Sincerely yours,

Michael Cheng
Microsoft Online Support
***********************************************************
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks.
 
Michael

I'll consider this one closed. I was hoping someone could point me to a good discussion of this topic, but no luck

----- "Michael Cheng [MSFT]" wrote: ----

Hi BBM

I noticed that another post of you titled "Cancel Database Update on a
Bound Form" discussing the same topic as this one. I have added my reply to
that post, if you have follow up questions, would you please add your reply
to that post? I will be glad to work with you :

Thank you for your patience and cooperation. If you have any questions or
concerns, don't hesitate to let me know. We are here to be of assistance

Sincerely yours

Michael Chen
Microsoft Online Suppor
**********************************************************
Get Secure! - www.microsoft.com/securit
This posting is provided "as is" with no warranties and confers no rights
Please reply to newsgroups only, many thanks
 
Hi BBM,

Based on my knowledge, a many-to-many relationship is really two
one-to-many relationships with a junction/link table, so it may be not so
complicated as you have thought to be :) I think you could have a look at
the following documents, which I hope will be a little bit helpful

ACC2000: How to Return Records in a Many-to-Many Relationship
http://support.microsoft.com/?id=209193

Microsoft Access Database Solutions - Handling Many-To-Many Relationships:
http://www.microsoft-accesssolutions.co.uk/many_to_many_example.htm

Thank you for your patience and cooperation. If you have any questions or
concerns, don't hesitate to let me know. We are here to be of assistance!

Sincerely yours,

Michael Cheng
Microsoft Online Support
***********************************************************
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks.
 
Back
Top