Unanswered: Drop down list refers to another table
Basically, my db has one tbl for "Clients" and one tbl for "Doctors".
Each Client can only have one Doctor, and a Doctor can have many clients.
The doctor tbl has a primary key field name DRID which is the Foreign Key in the Client tbl.
I have a form where the user can enter the client details. I want the user to be able to select a doctor already in the system by clicking on the drop down list and selecting it from there. If the doctor isn't on the list, I want a button to create a new doctor.
I've tried doing this using a subform on the main frm - but can't seem to get things to work quite properly.