>Dear Expert
>
>Field1 of Table1 has following numeric data
>1
>5
>4
>3
>2
>After indexing on field1 the records appears in ascending order
>but after closing table all records goes to their old location.
>Is there anyway : whenever I brows table then all records must appear as
>1
>2
>3
>4
>5
>
>In otherwords how to change nutural record order?
>
>Please help

There is no need for that though it can be easily done by scanning in certain order and copying to another table.