Hi:

I work at a school as a DBA and I am trying to create a cummulative report for each student graduating 8th grade.

I have a 'People' table that has a 1:M relationship with my 'Student Roster' table (each current student People type can have many related student roster records)...The 'Student Roster' table has a 1:M relationship with 'Class Roster' which has a 1:M relationship with 'Classes' table ('Class Roster' table acts as a Join table between 'Student Roster' and 'Classes').

Basically I am trying to Display, on a single layout, multiple student roster records and related grading info.

Any advise would be greatly appreciated...

thanks

russell

So your "Class Roster" is really an Enrollment table (it records a Student's enrollment in a Class).

To get a report that shows multiple Enrollment records, it's best to use a sub-summary report based in the Enrollment table. If your "grading" information is stored in that table, you should be fine basing the report there. If the grading information is in a separate Grade table or something, you may need to base the sub-summary report there.

Yes, the "Class Roster" is an Enrollment Table I suppose. The problem is not getting the related grading info to show for a Class Roster record or even for a 'single year' student roster record. It is displaying multiple years for one student.

Thank you for your help...

Edited June 12, 200718 yr by Guest

The problem is not getting the related grading info to show for a Class Roster record or even for a 'single year' student roster record. It is displaying multiple years for one student.

I think you missed describing the relationship to your "grading" table. Maybe you can fill this in for us and say what grades you want to see on the report.

Yeah I did. I apologize...but after you said that it triggered an idea

I solved the problem...basically i just created relationships usuing constants to display each year of the Student Roster correctly.

thanks for your help!