Dynamic List from Pop Up -- Why am I making this difficult?
Ok, first off thanks for the answers on my last question Phil and Guy.
My issue is this:
I have two tables. Table 1= Clients Table 2 = Doctors.
I want to do the following:
I. Using a pop up (why drop downs dont work at all baffles me) menu I want to choose a doctor (from Doctors table) from the list of doctors and populate a field on the client layout.
II. I want to show the Doctors Name - the data in the 2nd field and not the Keys.
III. I want to then in a separate field show the Doctors Phone Number - I want this done automatically.
IV. I would also probably need to in a report show the Doctors name again and not the Key field which is stored in the field from step 1. When I am doing this I keep getting the fK# stored in the field in Step 1.
Is there a way to do this without a scripting night mare. I attached screenshots of the database I made for this example.
Any insight is appreciated. Thank you in advance.