Data Model ~ Purchase Orders with Inventory...
This data model was designed to handle Purchase Orders with Inventory management. (Note, there only tables included in this database the balance is up to you!) To download the Data Model click here.
You may want to sort your Inventory by Category
Inventory will need to be stored
There many Purchase Orders
Each Purchase Order will have a Vendor
You will want to know who ordered (requistioned) the Inventory
Purchases may require an Expenditure Code
Vendors will have Types
The difficult I do immediately, the impossible takes a little bit longer.