Database design that I can't seem to wrap my head around.
Adding MySQL/PHP on a 10 year old html/css/js site. Current avg page size of about 75k.

I Have:

1100 transfers //paint by number patterns
700 transfers catagorized by a sku#

120 different paints // each transfer recommends up to 28 paints

I need to end up with a detail page of a transfer that includes an (html)table
with the up to 28 recommended colors. Each color (png background) includes
checkbox for inclusion with the transfer order.

Any comments welcome something will turn the light on....