I have the need for off campus professors to view the attendance history of their students.
I am writing the application is classic asp with vbscript.

The database has a table for attendance but each student get a new record for each date the class meets and whether the attendance status was present late or absent.

My main procedure gathers the instructor id, which course he wants to view and returns a class roster (Distinct list of students) with the totals of each type of attendance status.

My final step is that they want to be able to click on the attendance status of a certain student and have those "n" amount of records shown.

I have looked at master / detail but all references say all the data has to be in a single row. Repeating section does not seem to accept a second recordset which would be the same database base table, but filtered on student ID (passed as a URL parameter)for the course.

What is an approach that I can make this happen? One master record with a many detailed record relationship.