Combobox Tricks

[.paul.]

SELECT EmployeeID, FullName, JobTitle, CONCAT(FullName, ' ', JobTitle) AS DisplayField FROM Table1

Then you can use DisplayField as your DisplayMember