Combo Box Blues . . . .

[ray_charles]

Hello: I'm really singing the blues on this question . . . .

I want to store a employee ID on a orders table, but, I don't want to display the Employee ID in a Combo Box, (the auto
number for employee is meaningless to the user), but rather
the employee name. I don't however want to store the
employee name (used in the combo box) in the Orders
DB Table, but, rather just the EmployeeID. That way if the
spelling of the name changes for any reason, the correction
will only be in the Employee table, and NOT the Orders table.

Hence my question: If I only have the Employee ID in the
Orders table, how then can I use a combo box to display
a list of employee names, then display the chosen name,
and at the same time store the Employee ID in the Orders
table? ? ? ?

Hummmm . . . am I going about this the correct way ? ? ? ?

Thank you all . . . . Ray . . . .

 

[DBL]

You need both the employee id and the employee name in the combo box. You should bind the employee id field to the appropriate field in the Orders table (form) you can then hide the id number so that only the name shows by opening the properties for the combo box, click the Format tab and where it says Column widths put

0;2

this hides the first column (id field) and shows only the employee name.

if you create the combo box using the wizard it should step you through this if you select the employee id field and employee name field for the combo box.

 

[ray_charles]

Thanks so much ! ! ! I should have picked that up from
online help . . . but . . . somehow I missed it. What I was
doing was close but not quite the same.

You helped me alot, and so thanks again

ray . . .