Extra SalesPerson = 0

[Pat]

I have a need to show a salespersons name instead of its code, no problem i will just use a combo box.
I also need the combo box to show "Waiting Labour" where the SalesPersonID = 0.

Do i need to setup a text box overlaying the combo or is there another way?

[HansV]

Let's say that you have a table tblSalesPersons like this:

x337.png

You could create a small table tblWaitingLabour with the same structure and just one record:

x338.png

Set the row source of the combo box to

SELECT * FROM tblWaitingLabour UNION SELECT * FROM tblSalesPersons

[Pat]

Damn, i have already coded it the other way with a text box overlaying the combo box.
I will remember that for next time though.

Thank you very much.