I'm sorry I started another ticket... my topic changed from the previous ticket we were working with so I thought I needed a new thread.
Basically, here's our problem... I'll replace our water filters with t-shirts... Imagine you have a t-shirt with two variables, color - red and blue - and size - S, M, L - and the SKU number varies based on how those are paired. When we're adding the rows to the table, we're adding first the colors as options and then the size. So there will be small shirt, medium shirt, large shirt, red shirt, and blue shirt with the idea that customers could first filter by size and then by color, or whatever.... But we need a small red shirt to have a different SKU from a medium red shirt or a blue small shirt.
Based on your previous post, it sounds like we need another table to assign the SKU to the various variable combinations? Or am I misinterpreting the information in the tutorial and creating our tables incorrectly?
Thanks so much for your help!