The Area being Modelled is :-
Customers and Inventory Management

This is the text of the question to Database Answers :-
Subject: Customers and inventory management

Question:
Hi
Im a little bit confused, can you guys help me please
here is the case
I have a database for managing client order, now i want to add inventory management to it.

Let say that I have different products made from different components.

I am producing let say the food products and I'm buying the packages stuff from a supplier

What kind of table to I need in order for that every order received the quantity are automatically
deducted in both the stock (packages) ibought from suppliers and my stock of food that i have produced.

Let say that a product A is composed of The Food + the bottle + label+ and the packaging A= 10F+ 1Bo + 2 La + 1PA

how can i deduce those quantity from my stocks

Sorry I'm new in access but trying my best to learn