Making a report of a many to many relationship

July 25, 20169 yr

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

July 25, 20169 yr

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

July 26, 20169 yr

Author

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