I need a combobox to get its list items from 2 different tables (with identical structures). I can't figure out how to create a query (for the rowsource) to do this.

Any ideas?