Center for Academic Computing:

A many-to-many relationship is really two one-to-many relationships with a third table. Explanation: A record in Classes Table has many records in the Students Table, and a record in the Students Table has many records in the Classes Table. Many students can take ClassID#8 and Student ID#7 can take many classes. Determine Table Relationships ... ................
................