Calculations in Portals (using multiple rows)
I have a portal which needs to communicate with the "layout above" it. In the portal I will have several orders from the same customer. when I enter a quantity of items sold I want that field to subtract from total number of items in inventory in the "layout above".
here is my problem. I can get the first portal row to do subtract, but the next row does nothing, and so on. Here is an image to explain better. The field "Total Drums" is the drums we purchased. The field "Drums_in_inventory" is the drums we have in inventory. the field in the portal named "Qty" is the amount sold. See how the numbers don't add up?..
Any help would be great.