I think what Tariq is saying is that if he X2-clicks on the table, in Explorer, then it will fire off as an incidence of VFP, with the table automatically "sorted" in the desired order. i.e. no user intervention. Thus the table needs to be in the required order natively.

However, he's been shown the (probably ONLY) method of achieving this, given the brains that have pondered the problem, and doesn't seem to want to accept reality.


>To do this you are going to copy to a new table. After copying to a new table you can delete the original and rename the new table to the original name.
>
>There are various ways to copy to a new table with a specific sorted order..
>
>1. Select * from (originaltablename) into table (newtablename) order by (sort expression)
>
>2. Open the original table. Create or set index to appropriate order. Scan the table and copy records one-by-one to the new table.
>
>3. use the SORT command.
>
>Once this is done, the records in the new table will only be sorted properly until a new record is added.
>
>you are much better off and more flexible using a structural index and setting the index tag when opening the table. This will ensure the index order is updated when records are added/deleted/modified.
>
>>There is nothing more to that, the physical sort would not change.
>>
>>Yes, how to sort physical sort according to given index?