two tables need to link for listbox

[Guest]

Hi,
I have fields in two tables that need to be represented in one column in a
listbox. The tables are identical with the exception that one of the tables
must be updated regularly from spreadsheets. The other table holds simialr
data in the same format but is custom for that project. This is done so we
don't want to have to keep inserting the custom records in each update. These
records have to be linked to other related tables, but can never be linked to
each other. How can I get a listbox to display the names from the two tables
as well as id's. The id's would be the bound column. I have one of the other
tables to begin the id at 10,000 so i can use the same link table. Can this
be done?

 

[Guest]

How about a UNION query?

 

[Guest]

the union query works well. The only thing is that the listbox must pass the
ID to a dependent listbox. It does not seem to do this. Any ideas? Cheers