AnsweredAssumed Answered

Grouped data report with data from different tables

Question asked by buck_5648798798 on Jul 21, 2010
Latest reply on Jul 28, 2010 by philmodjunk


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