combo box

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

René - 11 Jan 2004 07:11 GMT

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 :(

Reply to this Message

Duane Hookom - 11 Jan 2004 18:08 GMT

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

Signature

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
>
[quoted text clipped - 5 lines]
>
> 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 :(

Reply to this Message