Important queiry for the inventory

[nardionline]

I have a computer store database .
when i make an order , i store the data into order details,, but some products have ingredients inside.
i wanted a query that would show the orders details not by products but by their ingredients.
Is it possible?
Thank you in advance!

[orange]

Please show us your table structures. What have you tried so far? What results?

[nardionline]

Please show us your table structures. What have you tried so far? What results?

I haven#t tried much.
I just have built my tables and relationships.
built forms that inserts data into orders.
but i can not query the order details to get sales , or inventory.
thanks in advance.

[orange]

Can you attach a copy of your db with some dummy data?

[nardionline]

i use the order details for inventory.

See attachment! (Administrator - RuralGuy)