I have a form that uses the Lookup Wizard to open up a dropdown list of Doctor's name from the doctor's table to fill in the numeric doctor_id value in this form that will be associated with that doctor's master address and other data record.
The next field in this form is to hold the value, also retrieved from that doctor's master table, of the doctor's medical specialty. In that field it is represented by a 1 or 2 or 3...etc.
What I would like DYNAMICALLY is that when one option is selected from the Dropdown list of Doctor's names that the value in the same table, same doctor's record, that represents his or her specialty also be retrieved and inserted into the next field in the form that is going to be submitted to make a report.
So that as soon as the user selects the value of the doctor's name pulled from the master table and that doctor_id is now a selected value, that the next field in the form is dynamically filled with the value for his or her medical specialty, retrieved from the same doctor's master record.
I have looked at cascading dropdown dependencies in the tutorial and what I am asking for is similar to that, in a way, where one dropdown is dependent on the live value of the first dropdown.
Here I am looking for one value to be retrieved for the next field based on the option value chosen from a dropdown list of values in the preceding field.
Thank you for your help.