complicated report on a student database

[JeffN]

Hi,

I'm a bit over my head here and would be grateful for any ideas that anyone has about this problem.

I'm working on a student database for my department. This database (whose relationship layout is attached in a pdf) has tables for students, teachers, and courses, and a join table called Enrollment that serves to show which students are in which courses and to hold the grades and attendance records.

What I'm having trouble with is creating a layout that shows, for each teacher, a list of all students in his/her classes, and for each of those students, a list of all their grades in each of their classes. So each line of the report needs to have the student name and a list of every course they're in--not just the courses of the teacher in question--and their grades in that course.

I've been able to get a list of students sorted by teacher by creating a layout based on the Enrollment table with a subsummary sorted by teacher. The body of the report has the student name and their GPA. However, getting that line to also contain a list of each student's courses and their grades in that course seems more complicated.

I've read that other people have used list fields and calculations for this. Or maybe I could use a portal? Or maybe am I going about it completely wrong?

Jeff