Showing Employee names

[Gary Nelson]

In Access2000(frontEnd) SQL server (backend), I have a form that I am
attempting to create. I need to have the employee name available in a
dropdown. Each employee has an ID number located in a table. I can get the
employee ID to show, but not the name. The fields in the table where this
data resides is called EmployeeID and NameLast,First. Table named
CompanyEmployees. Please help.

Thanks in advance

 

[Bob Sullivan]

Dear Gary,

If you want the name to appear next to the ID, set up
your combo box to display all three fields, but only use
the EmployeeID field. In other words, when you click on
the drop down button on the EmployeeID field, all three
fields will show underneath the field, but only the
employeeID field will be placed in the field.

Is this what you want?

Bob Sullivan
Springhouse