add to stock level when barcode entered
Hi, i have an inventory database and i want to add stock and minus stock using a barcode scanner how do i do this. for example i scan an item in (or type barcode) and the item comes up and i select add or minus so that the stock level increases or decreases. instead of looking up the item and changing levels continuously.
Any help will be really appreciated.
Also how to i set up the data base to automatically create an order/Purchase form when the stock has reached the reorder level.