Hi,
For adding products in database which are to be sold online, I want table structure for products which should be able to handle products which have 2 dimensional options like the size and color. Like for a product, size L available in colors red, blue and green and size S in colors Red and blue only. I want to add this product as one record in databse and its options can be in other table. I am not sure how it will be possible to handle this:
My table can be:
Product Table
ProductId
ProductName
ProductDesc
Price
Option Table
OptionId
OptionType
Link Table
ProductId
OptionId
But the problem is that these tables will only be able to handle either color or size seperately and not both together.
Your suggestions will be very valuable for me
Thanks
For adding products in database which are to be sold online, I want table structure for products which should be able to handle products which have 2 dimensional options like the size and color. Like for a product, size L available in colors red, blue and green and size S in colors Red and blue only. I want to add this product as one record in databse and its options can be in other table. I am not sure how it will be possible to handle this:
My table can be:
Product Table
ProductId
ProductName
ProductDesc
Price
Option Table
OptionId
OptionType
Link Table
ProductId
OptionId
But the problem is that these tables will only be able to handle either color or size seperately and not both together.
Your suggestions will be very valuable for me
Thanks