First thing that comes to my mind.

SELECT Field1, Field2, Field3, Field4 FROM GridRecordSourseTable;
UNION;
SELECT Field5 AS Field1, Field6 AS Field2, Field7 AS Field3, Field8 AS Field8 FROM GridRecordSourseTable;
INTO CURSOR NewGridRecordSourse

with proper conversion of types and PADing. Then you need to index the new cursor so the records to be ordred the right way.


>Hi all,
>
>I've got a grid in a form that is too wide for the form. The users can scroll to see all the information, but asked if it was possible to split each record into two lines so all the information could be seen at once. For example, here's how it is now:
>
>field1 field2 field3 field4 field5 field6 field7 field8
>field1 field2 field3 field4 field5 field6 field7 field8
>field1 field2 field3 field4 field5 field6 field7 field8
>
>What they'd like is:
>
>field1 field2 field3 field4
> field5 field6 field7 field8
>field1 field2 field3 field4
> field5 field6 field7 field8
>field1 field2 field3 field4
> field5 field6 field7 field8
>
>Is this doable? If so, can someone please point me in the right direction?
>
>Thanks!
>
>John