>Hello Edward! How are you?
>
>Maybe you can help me?
>
>I have a grid, and in dynamicbackcolor i have the follow code IIF(MOD(RECNO(),2)=1,RGB(255,255,255),RGB(192,220,192)), but in the header of any columns i change the order of my table, by sample:
>
>thisform.grid.column1.header.click=set order to tag cust_id
>thisform.refresh
>
>thisform.grid.column2.header.click=set order to tag name
>thisform.refresh
>
>The problem is, when i change the order of my table the grid did stay disordered
>
>
>Thanks
>Anderson Reis Girardi
If you use a view or SQL-Select instead of a table your records will always be numbered from 1 to n
Barbara