counterfox3 asked: hi all,
i need suggestions on what is the most effective way to manage stock in a order system.
i have tblcustomer, tblorder, tbl,order line,tblstock, tbl supplier
so far i have built an update query which has the orders table and stock table and in the “current stock amount” field in the update part i put stock![current stock amount]-[order line]!quantity
and theres a parameter for entering order ID
so wud it be better to create a button in the orders form to run this query so its used every time an orders made?
i have a “quantity to order” in my stock table whats the best way tto manage this without manually entering it?
whats the best way to produce a stock report showing what needs 2 be ordered
or have i got it all wrong?
please can everyone who answers put it in simple steps please
and thank you for all who answer
Question posted courtesy of: Randy
Share and Enjoy:
These icons link to social bookmarking sites where readers can share and discover new web pages.