Database Layout For Oscommerce

[Vulcan]

I have a Category and Product table, it lists all the categories, and then inside those it lists all the products assigned to that category. Simple stuff.

But what would I do if I had a product that had multiple sizes?

Would I just create the exact same product but with different data in the `product.size` column, and then if more than 1 match was found for `product.title`, cycle through all the matches and list the content in the `product.size` column in a <select>?

Thanks.

 

[Vulcan]

Would I remove the stock & size columns from products entirely then? And then add those two columns in the size table?

Or just have additional sizes in the size table and leave the default ones in the products table?