stock access database help?
Monday, March 17th, 2008ok 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










