Hi Everyone,

I am making a database for inventory management. Everyday a certain quantity of material is assigned to different machines and record is kept for each machine. At the end of the day some of the unused material is being reversed to the warehouse.
I am having difficulty in figuring out to determine the exact material which is used for a certain machine.
Can you guys tell me which function to be used and how ?