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

    sam0723

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

      The relationship is shown as follows

       

      student-->test(portal)

       

      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