changing the order of a numbered list

[peabody]

I'm trying to take a list of records, each uniquely numbered 2, 4, 6, etc. up through 100, and dynamically change their ranking values if one of the records changes values.

What I mean by this is if the record with a field value of "2" needs to change to "16", and then what used to be "16" needs to go somewhere new.

I can't figure out a good way to control this change process. There seem to be two issues, one of the leapfrog state where there are two records being affected simultaneously, the one with the current value and the one with the destination value ... I'm not sure if I worded that very well.

The other issue is a way to have all the remaining, unaffected records shuffle accordingly.

Thanks!

[Vaughan]

What you have to do is script the whole process really tightly. In a system I did I put little up and down buttons on each record (in list view) so moving a record was just a matter of clicking the appropriate button on the desired record. The process went something like this:

Initial settings: all records found and database is sorted by sort number ascending (small numbers at top). Sort numbers are (in your case) even.

Move record up script: minus 1 from sort number, reserialise records using the replace script step, resort database.

Move record down script: add 1 from to number, reserialise records using the replace script step, resort database.

That's it. Pretty simple really. The trick is replacing the serial number each time. Note that you *do not* want to base your sort or reserialise a field that is used in any relationship!