Ok I am very lost on this part. I have Products and each product has 4 Product Conditions. These Product Condition Codes are NSOP NSSP USOP USSP . Each Product has a parent. Basically Just the Product. Each Product has a Unique SKU Identification Code called ProductParentSKU . They are 11 length Alphanumeric String. Every Product Variant has a Unique SKU also. It is the ProductParentSKU and then NSOP NSSP USOP USSP suffixed on the end. Example Parent ProductParentSKU would be 59KNC5BWM3K and the Variants would be 59KNC5BWM3KNSOP / 59KNC5BWM3KNSSP / 59KNC5BWM3KUSOP / 59KNC5BWM3KUSSP.
I have just read for days and have tried to set my tables up the best I can with the knowledge I have collected. I have a main table for all the product called ParentProductTable . I then in that ParentProductTable table have 4 fields for each ProductVariantSKU . Like I said this is just what I have read. Wrong or right Who knows. i read that I needed to set it up like a Customer Order table with a Order Product Table. So I assumed I needed a ProductVariantTypesTable wich I made and I now have to link it back to the fields in my main table.
This is where i am lost.
1: Is this a self joining or what?
2: How do I set it up so that when a customer orders a variant that i can input the correct variant and MS Access get the correct Variant of NSOP NSSP USOP USSP?
3: Is my tables EVEN set up correctly???
I know I could just make every variant a record but that would Quadruple (4X) the amount of Information in the Database causing severe redundancy and performance problems. I have attached several photos in hoping they can help you HELP ME PLEASE! I thank you all for your time and advice!