I am trying to design a set of tables but am having some trouble. The end result is I am hoping to store the data for seven reports, each report will contain various measures and each measure will have a different value for each of the seperate vendors (currently 5). so far I have somethign like this in mind.

Name: Image1.gif Views: 149 Size: 13.5 KB

But the problem is when there are more vendors, i dont want to have to re-design the data table but cannot think how to do this. My end result would be a table that looked like data with the vendors value in different columns but I want to create from an sql pull of the other tables.