Dear All,
I have created a inventory database with all the tables and form completed, however i have trouble displaying the onhandqty on the form.
my idea would be once i selected the product category on the form, it will automatically show me the onhandqty balance on my issue form so that it will prevent me form issuing materials more than what i instore. I have attached my sample database above. Any help is appreciate!! thank you all. Sample Inventory.zip