I need a step by step on creating a many to many realation!

[Enuma]

I am having problems in understanding it ive tried many guides but i still dont understand it.

Maybe if someone explain me with their own words.

[bcooney]

You resolve many-to-many relationships with a join table.

For example, Students and Courses. Each course can have many students. Each Student can take many courses.

So, create a third table, Enrollment, that stores the combinations of a student and a course. If Sue takes 5 courses, there will be 5 records in the Enrollment table with her StudentID. Each of these records would have a different CourseID.

Student Record

ID Name

100 Sue

Course Record

ID Name

4000 Biology

Enrollment Record

EnrollmentID StudentID CourseID

1000 100 4000

This is Sue's Enrollment for Biology.