» 
Access prob's
Ok, I am having problems doing a Update query to my database. It's for a plant nursery. I need to do an update query that will update the inventory data when a new order is filled. I have a Inventory table with the Plant ID and Quantity; a Order-line item table with the Order ID, Plant ID, Quantity, and Price; and a Customer order table with the Order ID, Customer ID, Date, and Y/N question. I also have a procurement, procurement line item, customer, plant, and supplier table which I believe are irrelevant to this query. How would I go about creating this update query, and it also wants me to have the criteria of today's date so that after an order is filled, the clerk can run the update query to update the inventory. Please help, any advice would be greatly appreciated!
| 
Linear Mode
