Combo box showing the primary key instead of text values

[Gameybeets]

Hello,

I'm posting an example of what I'm trying to do here. In "example" file, I have the vendor table which keeps the record of all the vendors. In the late payment vendor table, I have vendors with late payment which I created with lookup wizard resulting in combo box. I did the same thing to termination table which I only want vendors used in late payment vendor table. The user should only choose from the vendors in late payment table instead of showing all the vendors from the vendor list. When I do that, I no longer see the text value of the vendor name anymore, and now I only see the primary key of the vendor. The reason I have combo box in the table is to create a form later with the combo box already set up.
I got around the problem in "example_01" by making the vendor name the primary key. However, I'm not sure if this is the right way of doing it.
Any help is much much appreciated!!!

 

[CJ_London]

check you have set the combobox up correctly

bound column - 1
column count - 2
column widths - 0;2
rowsource - something like 'select vendorID, vendorName from tbleVendors'