4 Replies Latest reply on Dec 11, 2016 11:16 PM by sam0723

    Get the maximum score of a student

    sam0723

      Hello everyone, i am new to filemaker. i am now working on student's test database.

      The following is the problem i face.

      The relationship of my database

       

      student >> Class >> Class Line Item , student>>test>>test history

       

      so in the class layout user could see details of a class. In the test layout, user could find out the test history of a student.

      My client now would like to have a report based on the class line item showing the highest score of the student.

       

      But my original idea is to separate the table clearly as shown above. i try to make a portal based on class line item table, but there is no relationship between class line item and test history table so i could not show any related data of the student. For the highest score, i think i will create a calculation field to calculate the maximum value of the score.

       

      my question is should i write a script to take the highest score of a student from the test history table to class line item table or modify the relationship between these tables?

       

      I am using filemaker 15.