Help linking database templates

[Guest]

I am using the Access templates Order Management and Inventory Control. Is
there someway to link these two databases so that when I enter a customer's
order in "Order Management" it subtracts that item from "Inventory Control"?

 

[Guest]

Hi Smithtribe,

You should probably just try modifying the design of your Order Management
database so that you can track the inventory there. Here is an article
written by Access MVP Allen Browne that you might find helpful:

Inventory Control: Quantity on Hand
http://allenbrowne.com/AppInventory.html


Tom

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

:

I am using the Access templates Order Management and Inventory Control. Is
there someway to link these two databases so that when I enter a customer's
order in "Order Management" it subtracts that item from "Inventory Control"?