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.