names in combo box with same number show only the first name

[mstekkie]

i have a combo box that displays occupations, and its corresponding number in a bound text box. for some occupations, they will have the same occupation number. eg. chargehand and foreman both have the code 1234567.

what happens is that when i choose foreman from the list, it shows chargehand. is there any way to fix the combo box so that it will show the occupation that i choose?

any help would be appreciated. thank you.

 

[vistor]

mstekkie,

I think you need a primary key number for each.
That is chargehand 1234567 and foreman 1234567 should each have their own ID number.

Try fixing your table, then recreate your combo box on your form, Use the Primary Key as the unique number when the wizard asks what you want to use. And pardon me if you have already done this, but that is what I think your problem may be.

CDWD

 

[mstekkie]

i've got a primary key for each, and i've redone the combo box. the different names do show up now, but i don't know how to show the occupation number. how do i bind a text box to the combo box to show the number?

thank you again.