Making a report of a many to many relationship

[muskee]

Hi guys!
I'm using fm 14, I would really like your help with making a report in which I need to show a many to many relationship. I know how to do this easily with sql but have no idea how it's done here.

Basically I have 3 tables:
Student ---< Enrollment >---- Course

Soo, I would want to see in a report a student and the courses he has picked and in another report each course with the students it has??

Please, would be really grateful of your help

[webko]

Both reports should run from the Enrolment table.

Student one, find on the StudentID and you should get a list of the related CourseIDs

Likewise, find on the CourseID and you should get a list of the related StudentIDs

[muskee]

Thanks!
That worked great, if I wanted to see what intructors the course has  and the students that are in that course,could I do that with one find or  how would I do that?
Student ---< Enrollment >---- Course---< courseInstructor >----- Instructor