I am trying to create a form that will allow me add products that has multiple colors for each of them. Example:

Product with code number '405' has 10 colors. Color number 1,2,3,4,5,6,7,8,9 and 10. And I have around 100 products, each one has 10-20 colors.

When I sell these products I usually sell a couple of them with multiple colors for each. The color listings for each product are not always the same (not always no.1-20, but usually it is)

I want to be able to select a product number in the sale form; '405', and add the colors that is being sold; '1,2,5,7,8,9,10' - and do the same for other products in the same order.

I am also trying to record these order as inventory out, and the purchases I make, with the same product-color style as inventory in - and show a balance of the inventory - and sales report as well. 

Now I'm stuck as to how I should begin to create a form to store all my products with their colors.

Please help me find a solution for this!

Thanks a lot!

Varin