AnsweredAssumed Answered

Linking multiple fields to auto enter based on one field

Question asked by NsaA on Apr 15, 2014
Latest reply on Apr 15, 2014 by NsaA

Title

Linking multiple fields to auto enter based on one field

Post

I am designing a medical database. Every record in the database reflects a patient's visit to the clinic. Every patient included in my database has a unique Database ID. So patient with PatientID 1 may have 5 records in the database as he has made 5 visits to the clinic.

      
     Every time a patient comes in, some fields in the same table "TableA" have to be filled repeatedly, like
     1) DatabaseID
     2) DateofBirth
     3) Ethnicity
     4) Sex
     5) AttendingPhysician
      
     Please help me write a calculation for the following:
     Everytime a Database ID is filled in, the other three fields should fill automatically based on past entries for the same Database ID.
     The user should be able to over-ride, that is, should the Attending Physician change, the user should be able to change it for that particular visit in the database.
     Also, the fields of Sex, Ethnicity and Attending Physician are chosen from a drop down list. I hope that does not matter.

Outcomes