Cascading Numbers

[wwyngaard]

I am in need of a way to prioritize active jobs. A user will assign a priority to a list of active jobs like 1-20. When the record assigned priority 1 is complete and removed from the list I would like 2 to become 1 and 3 become 2 so on up the list. If a user get a new job that must be given priority 1 the rest of the jobs need to cascade down a number. Or if he assigns it a 5 the current 5 becomes 6 and on down.

Any ideas.

Thanks,

Wayne

[BobWeaver]

There's probably lots of ways to do this, but a simple way that I have done in the past is to get a found set of active jobs, sort by the priority field and then renumber the priority field either with the replace command assigning serial numbers or a script with a loop.

To change the priority of a job, you can give it a number like zero or 2.5 to insert it in the proper position and then perform the renumber operation described above.

You can create buttons that move the current record up or down or to the top or bottom of the list by adjusting the priority value and then doing the renumber operation.

[wwyngaard]

Thanks,

I think that will work doing a renumber with a loop.

I am open to any other ideas though.

Thanks,