401K Financial Planning

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