What type of database is this?
Can you create the following links?
From To On
tblStudent tblStuCoursJunc studentID
tblStuCoursJunc tblCourse courseID
tblStuCoursJunc tblGrades juncID
Group on tblStudent.studentID or, if you need to have it in alphabetical order by student name, then create a formula and group on that. Set up the group so that the group header repeats on every page. Put the student info in the group header. Turn on "New Page After" in the Group Footer.
Then sort on either CourseName or CourseID (depending on the order you need) and put the course and grade info in the details lines.
-Dell
IP Logged
