Avatar of dresdena1
dresdena1
 asked on

Access 2007 inventory management

EE,
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.
dresdena1
Microsoft AccessMicrosoft Office

Avatar of undefined
Last Comment
dresdena1

8/22/2022 - Mon
john15nlt

So I inderstand, you have a form to process orders that is not automatically adjusting the inventory or you have other sales that are not processed in the form and need to adjust inventory based on those?
Eirman

A running inventory doesn't sound that difficult to implement.
If the database is not proprietary and you posted it with some sample data it would be a great help to us.

Failing that, a screenshot of the relationships in the backend database would be very useful.
dresdena1

ASKER
Thanks for the quick responses!

john15nlt,
It is not automatically adjusting inventory.

Eirman,
I have opened up a basic query and added the primary tables so that you can see the joins. I am attaching a screenshot.

Thank you.
dresdena1
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.
rwheeler23
Eirman

I am attaching a screenshot.
Try again!
dresdena1

ASKER
Ooops. I attached it but didn't hit upload.
ee-db.jpg
Scott McDaniel (EE MVE )

Do you have other tables? In many cases, you'll have Inventory tables, Transaction tables, etc.
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
ASKER CERTIFIED SOLUTION
PatHartman

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
SOLUTION
Log in to continue reading
Log In
Sign up - Free for 7 days
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
dresdena1

ASKER
Thank you. It appears that it may be more complicated than I had expected.
Thanks again!