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 Hobbies/Student :-

Adding Student to a Hobbies Database

Master & Sub-Form

Video 2  (5:43)

Video 2  (5:43)

More Info on Master & Sub-Form:-

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 Master Child Link:-

..             ….                ….                     ..                  ..                 . .                  …                   ….              ..               .               …             .. .          .. .. .                 ….

.. ..

Rank with VBA

Rank with VBA Heading HERE… Video 1 (7:06) This 1st video follows along from the presentation below. The presentation goes over the basic idea, then the

Read More »

Value

Use “Value” or Not? I’ve noticed a couple of minor glitches caused by the default of a ‘textbox’, the value; not being assigned explicitly. It’s

Read More »

More Useful Stuff HERE:-