Add Inventory to Order Entry Database

[Scott H]

I have a small publishing company that I am trying to create an inventory and
order/invoice database. I was hoping to use the Order Entry template from
microsoft. I have some understanding of tables, queries, and forms, but not
sure how to tie in an inventory piece so that I can add new inventory, keep
tabs on stock as well as track when stock is taken out of inventory at the
same time I create an order for a customer.

Any help would be greatly appreciated.

 

[Allen Browne]

Big question. This article might point you in a useful direction:
Inventory Control - Quantity On Hand
at:
http://allenbrowne.com/AppInventory.html