Many to Many Relationship

Many to Many Relationship - 3 Video's

In their simplest form Many to Many relationships are just two columns in a table. The first column representing one side of the Many to Many Relationship and the other column representing the other side of the many to many Relationship. In this particular example we have students against hobbies. The information represents a student in the left-hand column and the right hand column represents a hobby that this student may be taking. You can also read the table backwards as it were, you could ask the question, which students are taking this particular hobby?

The Many to Many name can be misleading because in essence, you only have one student related to many hobbies, and the reverse, one hobby related related to many students. But as you can see in the table, you have many students on the left and many hobbies on the right, hence the misleading name – “Many to Many”!

The following Videos demonstrate the use of a subform in a Many to Many Relationship.

The videos Video 1 and Video 2 show the many to many relationship from both sides. One side, using students  matched against hobbies, and the other side, hobbies matched against students. There is an extra video showing you one or two problems you might have, and the solution(s).

Adding Hobbies to a Student Database

Master & Sub-Form

Video 1  (4:35)

Video 1  (4:35)

More Info on Hobbies/Student :-

Adding Student to a Hobbies Database

Master & Sub-Form

Video 2  (5:43)

Video 2  (5:43)

.. ..

Synchronisation not Working

Master Child Link

Video 3 (2:29)

Demonstration showing a main form subform arrangement that hasn’t been synchronised properly. You can clearly see that the data is not synchronised correctly. Shows how to set up the master child link with the Subform Linker Dialogue Box.

Video 3 (2:29)

.. ..

Posts Related to this Blog:-

The link(s) below relate to various discussion(s) related to this Blog. Visit these and you may find someone else has already solved the problem you are having. You may want to post a new question to clarify the process of using this technique for handling Many to Many Relationships. This concept has many names:- “Associative entity” “Junction table”

More Useful Stuff HERE:-

This website uses third-party software - WordPress Add-Ins to be exact. I don't know what any individual add-in does, but I'm sure that many of them collect information about you. So be aware, if you continue using this site, then you are likely to be sharing your information. I don't know how to disable this sharing for any, or all of the plugins for individual users. So I can't stop the sharing of information. If this worries you then please do not use this site... If you continue to use this site I will assume that you are happy with it.

Do you need a hand in the right direction?

You are in the right place.