I'm trying to calculate the quantity of stock in an organization. I have a text box to reflect the current quantity, another for the no. issued to staff, and another to show the remaining balance. However, when any of these is used, the balance reflected is correct, but the quantity stays the same when i select the same product later. How can i update this quantity so that the stock level reflects correctly? Should i have another form specifically for this purpose? Thanks for your help.
-
-
Hi
If I ubderstand this correctly
current quantity = No. issued + balance
If this is correct, and by 'used' you mean issued, then why would the quantity change??
If this is not correct then I do not understand the problem!
MTB -
How is your table set up, and which of these fields are bound to the table?Comment
-
Hi
Hi MTB
No, what I mean is, the staff are usually issued with these items from the store, so whenever any item is given out, then the current quantity should drop by that number so as to reflect the correct figure, right? This is the figure displayed in the balance textbox. The only problem is, the balance is calculated well, all right, but how can i now reflect this value in the current quantity textbox, so that when someone comes for the same product next time, we have an accurate reading concerning the number in stock?
Thanks for your help MTB.Comment
-
Well, as I see it the No. in stock = balance ??
Therefore the result of this calculation should be displayed when you need to Issue the next item!?
I think pehaps if you answer ChipR's question we may be able to help further.
MTBComment
Comment