4 Replies Latest reply on Jul 28, 2017 8:06 AM by sam0723

    Get the maximum of the related records

    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