Page 1 of 1

Material Inventory and Material Issue showing the Totals.

PostPosted: Wed Sep 07, 2005 12:11 pm
by filemaker_power
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

Re: Material Inventory and Material Issue showing the Totals

PostPosted: Thu Sep 08, 2005 3:18 am
by AndrEw
filemaker_power wrote: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


Greetings.
What version of your FileMaker?