So i have a table and design of this.
in the subinventory if i want to view first the stock input a subinventory on textbox then print on the other textbox w/e itemcode, itemdecs, subinventory, uom and requisition.
now if i want to order on subinventory textbox in the second i will put any numbers that will subtract to the current number in the itemdb and if the stock is lower than 100 it will show a msg box that the current stock is lower than 100, and if the stock is 0 it will show a msg that the stock is out of stock.
tyvm