cRemaining = Length - Sum ( Usage::Retuned_Roll_1 )

This is the formula i use to update my inventory from other fields. But i have a question. I set up my job page layout "Where I subtract how much i use of a roll of paper) so that I can select many rolls on one job which is normal.

What happens when you have Returned_Roll_1, Returned_Roll_2, Returned_Roll_3 as fields that I need for reports but updating one specific field on Inventory based off which roll I select to start with from drop down?

Basically i need to know when I use a specific roll if it was the first second or third roll used on the job. That is the reasoning behind me doing it this way.

Am I doing something wrong or are my questions to complex? No one has been able to answer any of them. Takes me a week to figure out so it tells me they are feasible but I'm new at this so i thought I could use this forum to help speed things along.

Unless im doing something wrong in asking I don't get how there are so many pros but very little answers..

Dont get me wrong im grateful with the help i have had but trying to aggressively pick this up fast so i can get on with my daily routine. (Which is why I purchased it in the first place)I hope i haven't made a mistake in doing so.

Edited February 17, 200916 yr by Guest