Many to Many Relationship Access College Database

Many to many relationships are actually two one to many relationships either side of table known as a junction table. Tis tutorial walks through the creation of the junction table, relating the appropriate fields and populating the junction table with data to associate different clubs with different students.

[scottaxton]

One of the best explanations of Many-to-Many I've seen! This makes it much more understandable. Thanks

[hapemokenela]

This series of tutorials on data relationships has been very informative and made easy to understand. Thanks.

[throsbychurch]

I have to agree with the others, this is a good explanation. I've never heard of a junction table before, let alone seen one. I built a students database back around 2003 for adding historical records from around 1900 and it worked well. But I upgraded to a new database version and my data corrupted. I tried a couple of times to rebuild it and I thought I had it working until I noticed corruption again. Records I was entering were being written to another students information. I decided to see if anyone built a students database I can adapt and found yours. I have created a portion of your database and adapted it. Instead of Clubs I have schools. It's not quite how I want it, so I will make more changes and see the results. Thanks for showing me something new and the easy to understand tutorial.

[fazerville]

This is a good explanation. Particularly how data flows through the joins is well explained and limitations made clear through the use of a query. Well done !

[emmanuelc.tuazama]

Very good and understandable explanation
It has helped me greatly, Thank you!

[mantjaneds]

You made my day!!! thanks for making it so easy

[Seraphyx]

Thank you, been trying to figure out how to do this. You explained how to do it and why to do it how you are showing. Made sense.

[nnflorian]

Watched all of your videos, thanks. How would design a "ReportsTo table" relation to an "employee table", where employees can report to each other for a certain period of time?

[joebox]

Nice explanation, but this is only half of the story. You normally need a form to perform such activity. Rarely someone is writing directly to the table. So how does one link multiple records in subform to a record in a main form. lets say via tick box.

[muhammadtalhazahid]

awesome explaination... but sir I have a question that can one table have 2 primary keys in  many to many relationships???

[shorthandtricks]

Sir very nice but i have a question does the clubs means(classes)

[ForexMoto]

idk why when i make relations theres no arrow that connects them