AnsweredAssumed Answered

Get the best result of student score

Question asked by sam0723 on Dec 15, 2016
Latest reply on Dec 19, 2016 by sam0723

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