There are 10 fields that can have multiple values. I did look into storing these in the main table but everywhere I saw "don't do that". You can see how I am currently fetching data in my reply to erix below.
Comment on Re^2: OT - SQL choosing a schema for index tables