Solved Combo Box rowsource from four different tables

[mafhobb]

Hi.
I have inherited a database that has several different tables (tblelectricians, tblplumbers, tblcarpenters,tblgardeners) and each of these tables has a field which includes names (electricianname, plumbername, carpentername, gardenername)
I am building a form with a combobox and as rowsource, I need all those names. I do not mind the order, I just need them all to appear on this combobox so they can be selected.
How do I do this?
mafhobb

 

[Gasman]

Use a union query whilst you fix the issue.
You should have one table with all those names and an additional field that describes their occupation.

What happens when you start adding new occupations?

 

[mafhobb]

The Union Query did it nicely.
Thank you very much!
mafhob

 

[mafhobb]

Hi Pat.
I agree with you...If I get to the point of having to do a new db version, then I'll try to redo this as you suggest.
Thanks