Help!
I have a patient form where their referring doctor is chosen and that ID for the doctor is stored in a variable. When I click "Save record" I need it to copy the data form the ReferringDoctors table (name, address, etc) and copy it to the PatientDetails table in corresponding variables based on which doctor has been chosen. I can't figure it out. Help!

Using Access 2013