How would you set this up...

Discussion created by TekGlobe on May 4, 2016
Latest reply on May 5, 2016 by mathepac

Here is the scenerio....


I have the retail store master SKU list. Lets call this INVMST table, a sub set of this list is taken from the store and then loaded into a Vending Machine. Let call this INVVEND, products are then sold from the vending machine.


My Vending solution is 4 tables, INVMST, INVVEND, TRANSACTIONS, and STORE INFO.


I only need a sub-set of INVMAST, this is Category 100. I want to scan the barcode of a product from the INVMST and copy this info to INVVEND. How do I best represent the relationship to accomplish this? Will a join table between the INVMST and INVVEND be needed or Just straight relation based on the Category? !