sql table set up for dynamic dropdowns
I have created a merchandise shopping page for mostly t shirts. We will be applying dynamic dropdowns to products that have multiple colors available in specific sizes. Can some tell me how my parent and child tables should be set up? Currently I have my parent set up with a SizeID, ProductName, Price, Size, Color Columns with the SizeID set as my primary key. The child table is as follows: ColorID, SizeID, ProductName, Price, Size, Color
Thanks!
Jackie