Suppose I have an Appointment Object, which has
Date, Specialization (picklist), and Patient(Master object-record type of standard object, Contact)
I have another object, Visit, which also have the exact same fields, in addition to a Doctor field(record type of standard object, Contact) Doctor has specialization, required.
When patient fills Appointment object, I want a workflow which auto-populates the doctor field in Visit object, matching the Specialization Picklist in Appointment, with the one in Doctor.
Is there any way to do this? Also, what data type do I set for doctor?
I am extremely new to Salesforce and know very little