Mahmood,
Larry is correct if you are showing the entire table in your grid. If your grid is a child table, with the link to the parent table being (for example) the field MyForeignKey, then your index would need to be "MyForeignKey + Location"

HTH
Barbara

>Hi All:
> Can any one tell me how to sort a table at run time. I am populting my grid and the grid is attached to a table. I want to sort my table according to location, thus when the grid is populated with the table, the grid too is sorted according to the locaiton.
>Thanks