I have a report that lists the attendance of a child.  Each page is the attendance for one class only.  Page two is that student's next class (or next student's first class).

I created a subreport that lists the notes that were entered for the child into our database.  These notes will be the back side on the child's class attendance report.  The notes have no physical association to a specific class.  The notes are just generically listed in the child's record in the database. 

To circumvent this issue we are using a 3 letter coding system in the note's title field to specify the class the note is for.  For example our Speech Group class is entered as "SPG".

Page one is grouped by the class (course table, coursetype field), then teacher, then student.  Data is displayed in the group footer for the student.  Obviously I cannot tell the subreport to print the notes for this class only because notes have to association to classes in our database. 

I can set up a formula to translate the class' name to the 3 letter code we use, but how do I get the main report to inform the subreport which class is being printed?

Thanks in advance for the help!  Hope I was clear enough.

you can also use the class code formula in the main report as a link to the sub report. in the link set it to link to the note title field in the sub report. I also assume you will need to link on the student's ID number.