AnsweredAssumed Answered

Get the maximum of the related records

Question asked by sam0723 on Jul 28, 2017
Latest reply on Jul 28, 2017 by sam0723

Hello, i am new to filemaker. i am working on a test report of students. The tables are based on the test result of a student.

 

The report structures like this

John(Sub-summary part)          

(Body)                               A                 B                      C          Total(A + B + C)

                      1.               40                 50                    60                    150

                      2.                50                70                    80                    200  

Jenny(Sub-summary part)

                      1.              50                 65                   70                      185

                      2.               51                56                    80                      187

 

a student could take as many tests as they could.

 

i would like to use conditional formatting to highlight the test with the highest score.

What should i do? could i highlight the related records only.

 

I am using filemaker 15

Outcomes