I have a database in Access 2007 that we use to process orders from our website.
We process orders into a form that joins the products, customers, order details, and order tables.
I would like to know if it is possible to input the quantity of products into the products table and then have it automatically adjusted based on sales that are input. Basically maintain a running inventory.
Is this possible? If so would it be difficult to implement. The database was setup by someone else a few years back and my knowledge is limited.
Any help would be greatly appreciated.
Microsoft AccessMicrosoft Office
8/22/2022 - Mon
This is the best money I have ever spent. I cannot not tell you how many times these folks have saved my bacon. I learn so much from the contributors.