Trying to Build Inventory for Tracking and Ordering
I am trying to create a database that will allow me to do the following three things: 1. List ITEMS that I can 2. INVENTORY 3. and 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.