AnsweredAssumed Answered

Unique Count of related tables

Question asked by sam0723 on Dec 12, 2017
Latest reply on Dec 12, 2017 by sam0723

hi, i am new to filemaker. i am working on the report of course attending by student.

The relationship of the tables are Student-> Course Attend-> Line item<- Course

So my report is based on the line item TO. The report format is shown as follow

 

subsummary part by studentname = studentname

Body = course

 

So the user would like to have numbering before the student name so that they will know how many student have attended courses within a year

 

But my report is based on the line item context, is that possible to count the student name

e.g. 1 John

          Maths

          English

       2 Mary

          Physics

          Maths

.... and so on

 

I have tried to create a summary field and calculation field to count, but the value is 1 for all student. It may be because the context is line item. Is there any ways to count number of student? Is SQL a possible way to do that?

 

i am using filemaker 15

Outcomes