I have an established database full of different products. I have a means to enter inventory changes for each product, but need the ability to break down my inventory according to two factors per product: size and color. I currently have a products table that is linked to an inventory changes table, and an items table that is used on an invoice layout for sales.
How do I do this? Do I need two new tables...one for sizes by product and one by color?