How do I combine a customer order database that tracks inventory?

[Duane Hookom]

Feel free to use the big empty space below the Subject to clearly state what
you have and what you want.

 

[cjaime3]

I have found a customer order database and a inventory database template both
separate on office online. What I need is a database which I can use to
combine these two. When I enter a customer order it also checks to make sure
the product the customer has ordered is in stock and if it is it will
subtract the qty and update my inventory.

 

[Duane Hookom]

Allen Browne has some information on Inventory Control at
http://www.allenbrowne.com/AppInventory.html.

--
Duane Hookom
MS Access MVP
--

I have found a customer order database and a inventory database template
both
separate on office online. What I need is a database which I can use to
combine these two. When I enter a customer order it also checks to make
sure
the product the customer has ordered is in stock and if it is it will
subtract the qty and update my inventory.

[/QUOTE]

 

[mnature]

Your first problem will be trying to combine the two templates. You can
import the tables, queries, forms and reports from one template to the other
([File], [Get External Data], [Import]). I noticed that some of the tables
have the same name, in which case you need to check that they have the same
format (to see if you can just use the same table for you combo database).
When you update the relationships you will have to link the imported tables
in to some of the existing tables. Even after setting up the tables and
relationships, you will still need to accomplish the daunting task of how to
update your queries and forms to reflect the new information that will now be
available.

Sounds like an interesting project.

I have found a customer order database and a inventory database template both
separate on office online. What I need is a database which I can use to
combine these two. When I enter a customer order it also checks to make sure
the product the customer has ordered is in stock and if it is it will
subtract the qty and update my inventory.

[/QUOTE]

 

[mnature]

Look at the Northwind sample database that comes with Access. I believe it
includes all of the parameters you ask for.

I have found a customer order database and a inventory database template both
separate on office online. What I need is a database which I can use to
combine these two. When I enter a customer order it also checks to make sure
the product the customer has ordered is in stock and if it is it will
subtract the qty and update my inventory.

[/QUOTE]