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
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
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?
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.
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.
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
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
I am attaching a screenshot.Try again!
ASKER
Ooops. I attached it but didn't hit upload.
ee-db.jpg
ee-db.jpg
Do you have other tables? In many cases, you'll have Inventory tables, Transaction tables, etc.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you. It appears that it may be more complicated than I had expected.
Thanks again!
Thanks again!