10 Replies Latest reply on Sep 19, 2012 4:06 PM by daveeed

    Calculations using values from related records

    daveeed

      Title

      Calculations using values from related records

      Post

      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?

      Thanks,

      David