Grouped data report with data from different tables
I need to track student attendance for an after school program.
The classes are once a week for 3 months.
I have a table for students, one record per student.
I have a table for the class with a portal to another table - class_lines. There is a line for each date the class meets. These are entered before the season.
I need to create a report that shows each date from class_lines. Under each date are all student names from the students table. Next to each student name is a Yes/No checkbox for attendance. I can't figure this out...
I've tried to create a report with grouped data organized by date but I can't get info from related tables to show up. I can get the dates from class_line or Student name from students depending on which table the report is based on.
I don't know which table to put the attendance Yes/No checkbox in either.
The relationships are as following:
Classes ---> Class_lines <----> Students
FMP 10 Mac 10.6.4