moving records around-changing the order

[JIM1945]

Is it possible in a db. that if you have several records in the db to change there order of entry around, like record 1-jim 2-joe 3-susan, I would like to chang this order if possible like 1-susan, 2-jim 3-joe. thanks

[cjaeger]

sure.

split those into 2 fields, sortfield(number) + namefield. now you can change the sortfield, sort by it and bingo. To make this sort order permanent, export all records after sorting, delete all records and re-import.