>>To get needed appearance you should first modify data into new cursor:
>>Select 1 as listorder,recno() as recno,field1 as f1,field2 as f2,field3 as f3, ;
>>field4 as f4, field5 as f5 ;
>>From table1 ;
>>Into cursor tmp ;
>>Order by 1,2 ;
>>Union All ;
>>Select 2 as listorder,recno() as recno,field6 as f1,field7 as f2,field8 as f3, ;
>>field9 as f4, field10 as f5 ;
>>From table1
>>
>>Doing this you should provide the same datatypes for corresponding fields. When it's done you can use cursor 'tmp' as grid.recordsource
>
>Edward, thank you so much for your help. This works well except, it shows the first 5 fields for every record then displays the 2nd 5 fields below - so I end up with something like this for a table - let's use 3 records for an example:
>
>f1,f2,f3,f4,f5
>f1,f2,f3,f4,f5
>f1,f2,f3,f4,f5
>f6,f7,f8,f9,f10
>f6,f7,f8,f9,f10
>f6,f7,f8,f9,f10
>
>Is it possible to have every other row as 1st five fields with the rows in between as the 2nd five fields? Like this:
>
>f1,f2,f3,f4,f5
>f6,f7,f8,f9,f10
>f1,f2,f3,f4,f5
>f6,f7,f8,f9,f10
>f1,f2,f3,f4,f5
>f6,f7,f8,f9,f10
>
>I'm a firm believer in "Where there's a will, there's a way". :)
Sorry, I made a typo in my previous reply. It should be "ORDER by 2,1" to get proper ordering. Try it , and you will get needed sort order. Note, that Listorder field will be really important, when you will make your grid fancier.
Edward Pikman
Independent Consultant