401K Financial Planning

counterfox3 asked:

ok i am building a database where it has orders and stock. so far i have dont the orders bit and im stuck on the stock bit.

i created an update query to delete stock from “quantity” of a item sold when i click a button in the orders form eg. write order in form and click the update stock button i made and a parameter to enter order id then the stock table gets updated.

what i want to know is is this the right way of going so far?

and i have a “quantity to order” field in the stock table and a “Order limit” field. What i want to happen is when the “order limit” has gone through in the “current stock level” i want a message or summin 2 say that the order limits reached and then a report can be made to show what needs to be ordered for it.

or is this a bad idea?

hopefully i dont need 2 program and all suggestions are very much apprieciated.

thank u to all who answer


Question posted courtesy of: Ronnie