Search results

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...

I have an MS Access table that contains colour codes and their relevant percentage with reference to particular products. Each product can be made up of up to 3 colours and I am trying to determine the most used colour for each product - so far I can determine the percentage of the highest...