G
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
Duane Hookom
Feel free to use the big empty space below the Subject to clearly state what
you have and what you want.
you have and what you want.
G
Guest
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.
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.
D
Duane Hookom
Allen Browne has some information on Inventory Control at
http://www.allenbrowne.com/AppInventory.html.
--
Duane Hookom
MS Access MVP
--
http://www.allenbrowne.com/AppInventory.html.
--
Duane Hookom
MS Access MVP
--
[/QUOTE]cjaime3 said: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.
G
Guest
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.
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.
[/QUOTE]cjaime3 said: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.
G
Guest
Look at the Northwind sample database that comes with Access. I believe it
includes all of the parameters you ask for.
includes all of the parameters you ask for.
[/QUOTE]cjaime3 said: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.