Hi all,

I need to make a table into a grid. (Not as in the thing you put on a form). This would have zones running down the left, ie. the first field of each record is a different zone. Then it would have those same zones running across the top, ie. the field names would be each zone, except for the first one.

The problem is that at design time I don't know what the zones are. Doing the left side is easy, just append a record for each zone. But doing the field names is something I don't know how to do programatically.

Or am I going about this all wrong? What I want is to take, say, Z1 and Z2 and go to where they intersect to find the price. Like a multiplication table.

Any ideas on how I should do this?

Thanks,