Variable Sort

[datalink]

We need to allow an operator to change the order in which related records appear in a portal. My thought is to have a 'Sort' field which would just be a number field and the portal would be set to sort to that field. Then we would have Up/Down buttons on each portal row which would trigger a script that would move the record up or down in the sort order by adjusting the number in sort field.

I'm having a devilish time writing the script that would handle this. Can anyone help?

[comment]

See if these can help:

http://fmforums.com/forum/topic/60325-manually-reorder-portal-records/page__p__285451#entry285451

http://fmforums.com/forum/topic/73214-change-the-order-of-line-items-in-an-invoice/page__p__346265#entry346265