AnsweredAssumed Answered

Dynamic List from Pop Up -- Why am I making this difficult?

Question asked by AlexBlair_2 on Jul 27, 2015
Latest reply on Jul 27, 2015 by philmodjunk


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.