Combine two tables to allow editing in new table to change original table

[FreshAirGirl]

We have food product data in Table 1 (each product has a unique id#) and Table 2 has our customer names with the products that they carry (same unique id# as Table 1).

We need to update the ingredients in Table 1, but want to prioritize the project by selecting the items carrried by our largest customers first.

So, I want to combine the two tables, sort by specific customers (Table 2), then update the ingredients in the new table and have the ingredients in Table 1 change.

I made a query and combined the two tables, but changes only showed up in the new table- they did not affect Table One.

Can anyone help?



TIA!

[Cottonshirt]

So, I want to combine the two tables...

you don't really need to combine the two tables.

what you want is to find the customer that buys the most ingredients, then sort them in descending order with the biggest customer at the top.

to do this you will need a query that joins the two tables, but it doesn't merge them. merge is separate thing. all you need is a simple SELECT query with a left join that counts how many ingredients each customer buys...

SELECT tbl_customer.customer, Count(tbl_ingredient.customer) AS ingredients
FROM tbl_customer LEFT JOIN tbl_ingredient ON tbl_customer.customer = tbl_ingredient.customer
GROUP BY tbl_customer.customer
ORDER BY Count(tbl_ingredient.customer) DESC;

something like that.



many thanks,


Cottonshirt