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.
This videos shows 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).
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)
More Info on Subforms:-