I have a database where I am entering data into a table (Table A) through a form.
Table A is full of patient information, then there are several empty fields relating to the patient's doctor's information (name, doc's address, phone, etc).
There is also a Table B, which is not on the form, but is full of information on all the doctors who the patient could possibly see.
What i would like to do is be able to choose the doctor's name from a drop down list in table A (which I have accomplished), and then have the rest of the doctor fields (address, phone, etc.) populate based upon that choice I just made from the drop down list. I know this must be possible, but I have not been able to figure it out. Any suggestions?