I understand your table structure. Just remember, if anyone has more than one specialty, you will need the second table to make a one-to-may relationship between physician and specialties. You should not put a repeating group in your one table, e.g. Physician, Specialty1, Specialty2, etc.

If the form's source object is the actual table itself (or an updateable query based on that table), then you don't need the RunSQL statment. Simply typing the specialty into the combobox will place that specialty into the physician's record for that field.

If the form is unbound, try using ADO and creating a recordset object to populate the information.


Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division

OK, I understand your table structure now. Just remember, if anyone has more than one specialty, you will need the second table to make a one-to-may relationship between physician and specialties. You should not put a repeating group in your one table, e.g. Physician, Specialty1, Specialty2, etc.

If the form's source object is the actual table itself (or an updateable query based on that table), then you don't need the RunSQL statment. Simply typing the specialty into the combobox will place that specialty into the physician's record for that field.

If the form is unbound, try using ADO and creating a recordset object to populate the information.


Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division

SerranoG:

Thank you. I will mess with it this morning. I don't have a physician with multiple specialties. Each one only has one.

The source object on the form is not that table. It would be easy that way. I am just trying to update the 'Physician' table when a physician specialty is entered into the 'Specialty' combo box. I cannot get it to work. I have it working to 'Insert' both a new physician and specialty to the table when a new physician is typed in the 'Physician' combo box and a specialty is typed in the 'Specialty' combo box, but that is all.

I am just trying to select a physician in the 'Physician' combo box and after it is selected, if a specialty is not displayed in the 'Specialty' combo box, type it in, press 'Save' and the specialty is added to the 'Physician' table corresponding to the physician selected.

Thanks again for all of your help.
Tony