I’ve gotta combo box that successfully pulls in codes from a manager table. Problem is the combo box shows drop down like 100, 200, 300, only this one column. I’d lke to be able to show the drop down like this 100 mike, 200 dan, 300 joe, I’d like to to see these two columns instead of just the one. Ofcourse the manager name comes from the same manager table too.

=[Field1]&[Field2] in the underlying SQL