Table look up reference retrieves ID instead of field

[epardo87]

Hello,

• I have a table with columns: employeeID, FullName and Supervisor
• the supervisor column is referenced to the column "supervisor" in another table which also has another column "ID" which I didn't select
• it shows the name of the supervisor correctly
• In a form, I'm using a Dlookup to retrieve the "Supervisor" by searching the "FullName" and instead of retrieving what is displayed in that column, it is retrieving the ID of the supervisor...

why is that? how can I have the name retrieved instead of the ID number?

this is the SQL of the field:

SELECT [tbl-Supervisors].ID, [tbl-Supervisors].Supervisor FROM [tbl-Supervisors];

I'd appreciate your help a lot! thanks!

[June7]

DLookup is inefficient method to retrieve the supervisor name to a form textbox or to table field. Properly constructed combobox or table lookup should be able to show the name while saving the ID.

That is the SQL statement for a combobox or lookup RowSource?
Is the BoundColumn property set to 0?
Is the ColumnCount property set to 2?
Is the ColumnWidths property set like 0";2"?

I never set lookups in tables. I build forms with comboboxes.