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? !