Anybody out there have time to give a clue to a newbie? I am working in fmp 8 for the first time, developing a file of student scores for my own use. The file has four tables: Students, Assignments, Assignment types ( homework, quizzes, essay exams, for example), and Scores.

Each Student is identified by a five-letter StdntCode, which serves as the match field between the Students table and the Scores table. A unique Assignment Number provides the match field between the Assignments table and the Scores table. So each record in the Scores table is identified with a particular student and a particular assignment. In addition, a two-letter Assignment Type Code provides the match field between and Assignments table and the Assignments Type table.

I have no trouble producing a report for each student that shows that student’s total score for all assignments, by creating a summary field in the Scores table. When I place that summary field on a layout in the Students table, it gives me a student’s total score, no matter where on the layout I place it: in the body, the header, or any kind of subsummary part I have been able to define. I have not been able to find a way to make that report show a subtotal score for each TYPE OF ASSIGNMENT that student has completed. What am I not understanding?

Welcome Dan,

You need a sub-summary in your report sorted by assignment type.