Comparison Feature Help

[Kapelluschsa]

Hey everyone.



I'm making a program for work, and one of the functionalities we would like to add is a comparison button. We have about 30 products, each of which has around 200 different measurements taken and documented into a table. What we would like to do is be able to pick one of those measurements, say overall length, and print out a report that then shows the overall length of each of the 30 products. This way we can print a report that can be used to compare any of the measurements accross every cooler to look for trends. Right now I am trying to use a series of combo boxes to accomplish this, but cant quite get it to work.

Thanks for any help in advance.

[LillMcGill]

What is the structure of the underlying table(s)?...
Are there 200 fields, each for a measurement, or one field for the measurement and one field for MeasurementType, or what?

[Kapelluschsa]

There are 200 fields for 200 measurements in the table. So there is a column for say overall height, one for overall width, one for overall thickness ect.