Join 2 fields in combo box

[GarageConcepts]

We have a Vendor table and Employee table we want to create a combo box for Payee that when dropped down show both Vendor and Employee in one list.

[pbaldy]

A UNION query:

SELECT Employee
FROM EmployeeTable
UNION ALL
SELECT Vendor
FROM VendorTable

Google for the various rules and limitations.

[Perceptus]

you could to join the 2 tables in a query. and then use that query to populate the the drop down. If you create the query first, there is a wizard to do the rest.

[orange]

Do you have clear definitions for Vendor, Employee and Payee? Sufficient to distinguish each from the others in all of your business processes?
Do you need a Payee table?

[GarageConcepts]

Thank you guys. The problem is solved. I just needed a Little help with the SQL on the UnionQ

[pbaldy]

No problem and welcome to the site by the way!