The difficult I do immediately, the impossible takes a little bit longer.
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!)
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
Download Sample (Access 2007 and higher and an unzipping program needed)