I'm busy with a shop for clothes and I have a few problems with it. All the clothes in the shop are different, so they each have their one record, but my problem is the next one; Every article has a size and a colour to choose, how can i create a database where people one the site can choose their Size and Colour and go on to the shoppingcart. I know how the system works, i did a few shops before but never with special size's and colours to choose. Normally people could only choose one article without any options.

Now i created one table for the clothes, one for the colours and one for the size's. This works a little but i can't update or insert one new product with the right colours and size's on one page. Am i doing something wrong, or is their a better solution for this problem. I know Storefront is a good answer but my the rest works, only these extra options doesn't fit in.