Before I will tell my problem I will give you a brief overview of what I am doing;
I have a system that I used to track Quantity Balance/Returned ; Quantity Dispensed ; Lot Number in which material was used.
Now we are using Inventory Card system to Determine which Lot Number that a certain material was Used ; How much Amount was Dispensed and How much Amount they Returned for inventory until that material is finish ; We want our system to put it in filemaker. Please find below our card sytem
I made a filemaker file with the following tables Materials & Materials Transactions
My problem is How can I Calculate my Quantity Balance with my present set up when they dispensed any amount. I cant get exactly on what I have on my Card system
I have attached my file that Im working with.
Thanks in advance.