FilterValues() checks if values in one list exist in the other list - it does not perform calculations or comparisons. If you want to know if a particular student scored 1650 higher on any attempt, try:
Max ( Sat::Score ) ≥ 1650
Looks like the Max ( Sat::Score ) ≥ 1650 is only pulling out the first related record from SAT Table. That's why I was trying to use the List function. Does that make sense? Is there a better way?
Also, SAT::Score is a calculation field and doesn't work with the max function....correct? I've made a cahnge to make that work.
If the calculation is done from the Students table,
Max ( Sat::Score )
returns the highest score of the student among ALL related scores in the Sat table. It shoudn't matter if Score is a calculation field or not.
Thanks again. It seems pretty straightforward but I still seem to be getting only the first related record and not the highest score.
Note Comment's first statement of his last post: "If the calculation is done from the Students table,"
Have you defined this calculation as a field in the students table?
If so, then I suggest analyzing the relationship linking these two tables to see what might not be set up correctly.
Seems to be working fine. Thank you.