Linking multiple fields to auto enter based on one field
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
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.