AnsweredAssumed Answered

Calcuation based on child records

Question asked by CarriePledger on Sep 7, 2010
Latest reply on Sep 7, 2010 by LaRetta_1


Calcuation based on child records


I would like to have a field that is a calcuation based on the related child records.  It seems a little tricky since it is not a numerical calculation.  The set up is this:

Medical records with a parent table for the patient and a child table listing all the laboratory values, 

Child table has attributes: timepoint (preop, postop) and result (high or low) and value (number)  among others. 

My goal is to create a field in the parent table that will automatically calculate "yes" or "no" based on the presence of high lab value at preop.  For example, a field that says "Does the patient have endocrine deficiencies"  I know it seems redundant but it is easier for the doctors to see that way.