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.
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