Lookup field shows ID # and not text

[kelkan]

I have a table where I lookup an employee's name from another table. When I use that table to create a form, the combobox that I add to find a specific employee lists the EMPLOYEEID instead of the text for the employee's name. How do you display the text instead of the ID?

[alcapps]

Set the Column widths to 0;1
column count 2
default column = 1

column 1 = id
column 2 = name

hope this helps

[kelkan]

It is already set to that and it is still displaying only the ID

[alcapps]

Ok can you post your form and partial table to see if we can help

also make sure your query for the combo box has the two fields in the right order or you will get that kind of errors.