In order to get right answers you've to as right questions. :)
You don't have to change field order in a table at all. You can assign ControllSource of the columns of a grid in any order you want.
Thisform.grid1.Column1.COntrolSource = "FieldA"
...
Thisform.grid1.ColumnN.COntrolSource = "FieldZ"
>
>I need to change table fields for different fields order in grid.e.g
>
>
>
>Thisform.grid1.recordsource=""
>
>Thisform.grid1.recordsource="table1"
>
>
>But I could not get proper answer from UT.
>Some body gave answer on foxite. You can check by following link
>
>
http://www.foxite.com/scripts/foxisapi.dll/foxite.webengine.openmessage?aid=_0Z50QJN43&mid=0000047925>
>if you have any other short method to do that, plesae help me again.
>
>Thanks
--sb--