Ordering Related Records w/ Order Field

[HiredGun79]

Hello,

I have an order database and an itinerary database - In the itinerary database, I have a field called stop_order and a foreign key field called order_number.

What I have is a portal on the order layout that lists the related itinerary stops. I already have the create new stop button working using "if else" and "count" to count the number of stops and set the "stop_order" field to be the number of related records plus 1.

On the order layout, I have the itinerary portal sorted by stop_order. .

What I need a little help with is creating the delete, move up and move down buttons that will go on each row of the portal.

The part I'm stumbling on is if, say, there is 4 stops, and the user deletes the middle stop, stop 2. . what is the best way to determine what related records are after that and go about setting the stop order field to the new value. . .

The move up and move down buttons have the same problem, though it's smaller since it only effects two related records. . .

By taking a guess, I imagine I'll use global fields in some way. . but I'm not sure. . I think I've been staring at the scriptmaker screen a little too long.

Thanks in advance for any advice!!