Many to Many Relationships

Many to Many Relationships

Hi there,

I am trying to create a database with a many-to-many relationship. Specifically, I am creating a database for a children's project, where each child is being mentored by a person. At the same time, each mentor has a number of children under their wings.

The idea of a many-to-many relationship is that there are 3 tables:
1. Mentor Name
2. Child Name
3. Mentor/Child Link Table

I have created tables 1 and 2. How do I go about implementing the 3rd table? And also: how do I then create a view where I can see all "mentors by child" and all "children per mentor"?

Thank you very much for taking the time to respond and shedding some light on this.