Combine two unrelated tables with the same fields

[lghovden06]

I have two tables of products each of them a different brand with the same field names
brand1:

material number
material name


UnitOfMeasure
Multiple
Bulked (yes/no)
Price
$/Gal

brand2:

same fields as above

table1 has 700 records and table 2 has 100
Each customer orders products from both brands. So what I want to do is for a customer's price list query, combine all of the products from both tables and then select the products that customer buys by using a (yes/no) field. I know I can using a union query, but then the query cannot update. So if we want to change a price of a product for that customer I can't unless I go to the base table, but if possible I would like to do it from that customer query.
Any ideas?
Thanks!!

[pbaldy]

Why do you have the data in two tables? Typically it would all be in one, with an additional field to denote the brand.

[lghovden06]

When there is a price change from our supplier, I download the the new price change from online in an excel format and then I import the excel spreadsheet into access to update that brand's product's prices.

[lghovden06]

I found a way to make your suggestion work while still being able to import an excel file. Thanks!

[pbaldy]

Glad you got it working, and welcome to the site by the way!