Complicated Layout Help

[Russell Brown]

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

[Ender]

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.

[Russell Brown]

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, 2007 by Guest

[Ender]

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.

[Russell Brown]

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!