Calculations using values from related records
For the following data structure
Tables: Patient ->> Evaluation
A patient completes many functional evaluations over many weeks.
For a given patient I would like to calculate the difference in their scores between the first and second evaluation as well as the difference in their scores between the second and third evaluation.
There is no limit to the number of evaluations that can take place (normally less than 6). I am storing PatientID, ID, Date and Score in the evaluation table.
Is this possible with Filemaker calculation fields?