Static Ledger balance

[VaTechTigger]

Hey Guys,

I need a hand with a calculation? I have a situation where I am keeping an inventory log. Inventory is defined by its barcode, then there are different lots of each barcode.

I was able to make a calculation/relationship that would keep a running total of the reagent on hand for each lot of reagent. (highlighted in blue)

what I would like though is a field that will have the total of the reagent at the time of entry of that record. So instead of saying 424 in the last column, which is the total of that particular lot in stock, line 2 would say 150 and remain that way.

I tried doing it in lookup, calculation and a calculated value. Thing is they were all delayed by one record, as in they dont count the field they are on as having been completed yet when they compute, so line 2 would instead read 100.

Any ideas?

Edited July 7, 2010 by Guest

[Søren Dyhr]

Your solution is unfortunately not particular well when it comes to scaling:

Watch this!

http://www.geistinteractive.com/content/inventory-transactions

--sd

[VaTechTigger]

Thanks for that link, it is saved for future reference. It is currently blowing my mind. I understand the concept, but I am taking baby steps here as I am a few weeks into learning Filemaker. I will def implement this as I go along and learn scripting and portals and such a little better.

Scaling issues aside, is their a way to calculate what I am looking for?