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.

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).

...

Adding Hobbies to a Student Database

Master & Sub-Form

Video 1  (4:35)

Video 1  (4:35)

More Info on Subforms:-

...

Adding Student to a Hobbies Database

Master & Sub-Form

Video 2  (5:43)

Video 2  (5:43)

More Info on Subforms:-

...

Synchronisation not Working

Master Child Link

Video 3 (2:29)

Sample Database HERE.

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:-

.. ..

Searching for Answers

Searching For Answers Searching For Answers Video 1 (1:27) Did you know that you can use Google to search Access World Forums and get a more

Read More »

Attach a Label

  Attach a Label Attach a Disconnected Label Video 1 (0:52) Attach a missing label – Nifty Access – The problem you are facing is, you’ve

Read More »

More Useful Stuff HERE:-