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

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?