>Greetings all,
>
>I'm hoping I'm making this more difficult than I need to and I'm missing something obvious, but the only way I can figure out how to display the following data would be to "rebuild" a grid whenever a new "chart year" is selected. The data is as follows:
>
>

><b>eProgress.dbf:</b>
>chart     c  25
>tip       n  5.2  <-- "Years" column from chart
>matrix    c  2
>epercent  n  6.2
>

>
>Example:
>

><b>Record1:</b>      <b>Record2:</b>     <b>Record3:</b>       <b>Record4:</b>
>chart: 1999          chart: 1999         chart: 1999           chart: 1999
>tip: 1.25            tip: 1.25           tip: 1.50             tip: 1.50
>matrix: 1            matrix: 2           matrix: 1             matrix: 2
>epercent: 3.13       epercent: 3.33      epercent: 6.67        epercent: 7.14
>

>
>It needs to display as follows:
>
>

>Years  Matrix 1   Matrix 2   etc...
>1.25    3.13       3.33      etc...
>1.50    6.67       7.14      etc...
>etc...
>

>
>Depending on the chart year selected, the number of Matrix' increase (or decrease), as do the number of "Years".
>
>Any ideas on how to do this?
>
>Thanks a lot!
>
>Rob

I assume this is for a sort of report, i.e., show results to users.

How about Excel Automation? That will let you control a variable number of columns.

Another option would be to generate a text-file, and display that to the users with the default text editor.

HTH, Hilmar.