1 2 3 Previous Next 31 Replies Latest reply on Dec 19, 2016 5:08 AM by sam0723

    Get the best result of student score


      Hello everyone, i am new to filemaker. Now i am developing a student test database.

      The relationship is shown as follows




      In the test layout,


      student could take test as many time as they wish.


      test layout


      student name: Peter


      Test Date       Reading  Speaking  Writing   Listening    Total

      1/4/2013            50           50            60            70            230

      29/3/2014          60           70            50            65            245



      so my question is how could i get the best result of the student and also the tests date?


      Should i write a script to copy the result of the best result data?


      I am using filemaker 15

        1 2 3 Previous Next