Access form controls

[mbilalk]

Hello,
I have two tables
1. Person
2. Doctor

DoctorId is in Person table as forfeign key.

I have created a form based on Query.
I am displaying person information (name, address, phone,..) along with its doctor info (Name, Address, tel). Name is in combo box which contains all doctors which are in doctor table.

For display its working fine but when try to change the doctor from combo box instead of changing Id in person table it creates new doctor record in docotr table... I also want that when i change doctor name from combo box its address and telephone should also change in respective text boxes.

Looking forward for solution.....

[missinglinq]

Obviously you've got something mixed up! The best way for us to help you is for you to to zip up your file and attach it to a post here. There should be no confidentiality issues with your doctors data, but if you your 'Persons" table actually refers to patients, and you have real patient information in it, you can very quickly create a blank database and Import (File - Get External Data - Import) all objects, and but when you get to the Tables tab, select Options, and under Import Tables select Definitions Only.

That way we'll hget the tables designs but no data. Then Zip up this file and post it here.

Welcome to Bytes!

Linq ;0)>