Thanks, plog - I see what you mean. Rookie mistake - each colour is not unique to a product so this would involve a 1-m relationship.
I have since discovered that this table is actually a derived table (I'm not sure if this is the correct terminology - it definitely isn't a base table...