1 2 Previous Next 15 Replies Latest reply on Jul 3, 2017 12:32 PM by patricia

    Alternative for Too many unstored calculation

    aaparvez

      This is sample DB. It has 3 tables. 1 mother table is Patient and 2 child are "vitals of patients" and "other of exam of patient" related to patient table with patient id as FK.

       

      In child table "vitals of patients" there are fields namely Date, Pulse, BP, Weight and then a concatenated field

       

      calculating with concatenation as

       

      If (IsEmpty(Date); "" ;  "Date: " & Date & ";") &

       

       

      If (IsEmpty(Pulse); "" ;  "Pulse: " & Pulse & ";" ) &

       

       

      If (IsEmpty(BP); "" ;  "BP: " & BP & ";" ) &

       

       

      If (IsEmpty(Weight); "" ;  "Weight: " & Weight & ".")

       

       

      Same  to table "other of exam of patient".

       

      Then in table "Patient there is 2 field one contain unstored calculation of vitals of patients::concatenated and another is other of exam of patient::concatenated

       

       

      Now i wanted know any other way to accomplish this particularly by script step populating.

       

      Thanks in advance

        1 2 Previous Next