AnsweredAssumed Answered

Trying to Build Inventory for Tracking and Ordering

Question asked by robomacman on Mar 24, 2009
Latest reply on Mar 25, 2009 by robomacman

Title

Trying to Build Inventory for Tracking and Ordering

Post

I am trying to create a database that will allow me to do the following three things:  1.  List ITEMS that I can 2INVENTORY 3and prepare an ORDER report.

 

The ITEM TABLE is pretty straightforward. It has 150-200 items. 

 

The ORDER TABLE has Order ID, Order Date, To Order, Amount (Item::Price * To Order) and Total (Summary Field:  Amount) 

 

 

 

How to I create a trackable Weekly Inventory and Generate Weekly Orders based on the numbers generated from the ITEM worksheet without having to select each item individually?  I really don't want to enter each item on the Inventory Table just to do this.

Outcomes