Complex table (at least for me)
In simple terms I have 3 tables: tblStudents, tblAssignments, and tblAssignmentScores where tblAssignmentScores stores 3 fields tblStudents_keyfield, tblAssignments_keyfield and no_Score. To simplify my scenario I've eliminated some criteria tables, however here's the gist of my problem. I want to build an HTML table that has tblStudent.FirstName&" "&tblStudentLastName data as row headers. Then I want that same table to have tblAssignments.Description to be the column headers (which shrink and grow as assignments are manipulated), and last but not least I want the students scores to populate the appropriate intersections in the table.
I'm stumped, I can create a table that shows all students and a given assignment or all assignments for a given student, but I need a printable table that shows all students and all assignments and each students scores. Can anyone help me?