OS: Windows 7 Home 64 bit
Version: Access 2010
Current design:
(note: * indicates a primary key)
tblInventory - *InventoryID (Auto), ItemID (text), CategoryID (text), SupplierID (num), CategoryID (num), InStock (num)
tblSupplier - *SupplierID (Auto), SupplierName (text)...