You can do a summary field that chooses the maximum based on the relationship from the student to test. That is probably the easiest.
Or you could do an ExecuteSQL something like (had to guess field names):
Let ( [
ID = student::id ;
Test = test::id ;
SQL = "SELECT MAX ( score ) FROM test WHERE student_id = ? and test = ?" ;
Result = ExecuteSQL ( SQL ; ¶ ; ¶ ; ID ; Test )
Thank you. i have created a summary field to get the highest score, but i could not see any data in the portal
What table occurrence (TO) is the layout based on and what TO is the portal based on?
i am using the class table as the layout and the portal is based on class line item.
Could i show the test result of students in the portal?