Material Inventory and Material Issue showing the Totals.
Posted: Wed Sep 07, 2005 12:11 pm
I have a Materials Inventory File with 3 fields Material ID , Description and Quantity.
There is another file called Material Issue with three fields Material ID, Date and Quantity Issued.
The material issue is done by Material ID showing Date and Quantity .
Question: How can I show in the Material Inventory file, the Quantity Issued details by Date and giving the Total Issued Quantity upto Date.
Please help me. It is very very important. Thanking you in anticipation.
Regards
filemaker_power
There is another file called Material Issue with three fields Material ID, Date and Quantity Issued.
The material issue is done by Material ID showing Date and Quantity .
Question: How can I show in the Material Inventory file, the Quantity Issued details by Date and giving the Total Issued Quantity upto Date.
Please help me. It is very very important. Thanking you in anticipation.
Regards
filemaker_power