AnnieRydenQrew Member4 years agoTable-to-table relationships for Inventory ERPHello, I'm working on creating a new ERP system for our Supply Chain Inventory/Procurement purposes. I've set up the App to have a parent table: "Projects" with a child table "Products". So, one p...Show More
DonLarsonQrew Elite4 years agoAnnie,Inventory gets complicated. Here is a model I have usedThere is a fair amount going on, but not by the standards of Off the Shelf Inventory Packages.This tracks the Manufacturer and the Vendors.Titanium Screws are made by a handful of Manufacturers but sold by many dealers at very different price points and with different part numbers.The Transaction Type Table is where I have Into Inventory, Out of Inventory and Inventory Adjustments which happen in the Inventory Transaction Table.I have not explained everything, but hopefully this will help.------------------------------Don Larson------------------------------
Related ContentMoving Fields from One Table to AnotherHow to Link Tables in a Complex Many-to-Many Relationship?Help connecting Table to Table RelationshipsHow to relate two tables with the key to a third table?Way to Duplicate Tables or Make A Template for a Table?
