combo box

[René]

I have a combo box on a form where we can choose from a list a physcian for a particular clien

I had the combo box set up and then realized that I had set all of my primary keys of the names of clients or employee

I went through and added CustomerID and EmployeeID and changed all the relationships so that they were correct

In my Customer table there is a field for DoctorID and Dr Nam

I tried to redo the combo box and now that Doctor ID shows up in the combo box instead of the Dr Name and the DoctorID is not carrying over into the Customer table. I need this for letters to be mailed to the respective physicians later

In fixing things, I believe that I have screwed them up

 

[Duane Hookom]

You should only store the DoctorID in the related tables. You can always add
the Doctor table to any queries in a report or form. Storing the Dr Name in
more than one place is generally not good practice.

Combo boxes on forms could have a
Control Source: DoctorID
Row Source: Select DoctorID, DrFirstName & " " & DrLastName FROM tblDoctors
ORDER BY DrFirstName, DrLastName;
Bound Column: 1
Column Count: 2
Column Widths: 0, 2


--
Duane Hookom
MS Access MVP

I have a combo box on a form where we can choose from a list a physcian for a particular client

I had the combo box set up and then realized that I had set all of my

primary keys of the names of clients or employees

I went through and added CustomerID and EmployeeID and changed all the

relationships so that they were correct.

In my Customer table there is a field for DoctorID and Dr Name

I tried to redo the combo box and now that Doctor ID shows up in the combo

box instead of the Dr Name and the DoctorID is not carrying over into the
Customer table. I need this for letters to be mailed to the respective
physicians later.