Hai everyone, I dont know how to update the stock in my program. Actually, I am having two forms one is to enter the opening stock and the other to enter the usage of stock. In the opening stock form i select the item purchased and enter the date of purchase, shop name, quantity, rate, amount and the opening stock, which is the quantity bought.
In usage of stock form again i select the item ,enter the date of usage and the quantity used. In the balance textbox i want to display the balance which is the opening stock minus usage. It can work for the first time but if i enter another entry in usage of stock form for the same item the balance text box should show the balance correctly, ie previous balance - current usage. The opening stock should be the same. What i have to do, i send the table design and form design please help me ,is there any modifications has to be done in the design.