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

 

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

Outcomes