Complex Reorder

[idomagic]

I am over thinking this and it has me so frustrated... I have a database that needs to be kept in "order" with each record needing to be sorted. The user may not always enter the data in order and so I am tracking each record with a serial number. When the user need to "insert" a line above or below they use one of two scripts. The scripts works fine but they are long and I know there is an easier way and it's just not hitting my brain. Any suggestions on how to better manage this would be great. I would love to streamline the process and eliminate mistakes.

[Fenton]

One thing. If you insert a record between 2 others, you only need to renumber those above it in the sort order. I would use a Loop, with an incrementing counter, as Replace Field Contents doesn't let you programatically set the start number. This would save a lot of time if they insert it near the end, which is likely.

For a new record, wouldn't the next number just be Max ( self_Constant::Sort_num ) + 1, which could auto-enter. It's pretty slow with a lot of records.