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=""
>&&after changing field order
>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