OK Jason I created another table with colorGroupID and colors so now I have two tables, one that has product data plus a new cloumn for colorGroupID which I have added to that table. And the new table which has 3 columns, an auto increment column and the colorGroupID and colors column.
Can I use this setup to extract the right colors for each product item? There are some 700 items, why it took so long!!