I am trying to develop a form with a grid on it. This will scroll in two directions, and all the rows and columns will be derived from data. The topmost, leftmost, bottommost and rightmost columns/rows need to be frozen as they contain summary, label, title and total data. A 'mock-up' screen shot is available at:
http://www.c3x.co.uk/materials.gif

The commodity pack ( left most column ) would have more rows than can be displayed and this is defined by the data, so as you scroll through the rows all the rows would have to change in each area except for the summaries for the house type at the top and sub totals and totals at the bottom.

The house type across the top is also variable defined by data, and you can scroll across the columns to see the data for each house type. I have the concession that I may lump house types and garages together so that the garage column are part of the same grid as the houses as the last entry. But the commodity pack labels must not scroll on the left and the totals on the right must always stay visible.

So I would like to create a grid, or possibly several grids, or possibly use a control that someone else has written. I am wondering if anyone has experience on this they would like to contribute before I start work.

My deliberations so far are:

1) If it is one grid is there any way to freeze rows or columns?

2) If it were several grids is it possible to make scrolling one cause another to scroll, reliably(!)?

3) Has anyone used or made a nice easy to use control that does approximately the same thing?

4) What about doing all this in Excel and then just viewing that from the FoxPro form.

This is being developed in VFP6.0, I have been told emphatically that 7.0 is not an option.

Thanks in advance for your help, advice and shared experiences.

Bye4now,

John.