Need ideas for a changing sort key

[M Skabialka]

I need to create a form where someone asks tasks which have to be
accomplished in order, the dates being irrelevant, though it will be
tracked. What is the best way to create a field that will prioritize these
in order? There will be many instances where a task is inserted or removed
from the list. If I have steps 1 through 5 for example, and need to add one
between 2 and 3, I don't want to have to renumber 3 through 5 as 4 through
6.

It's a tool to train new employees how to do their job, the series of tasks
will change from project to project so I'd like to create a master list for
a project, and they can add or delete tasks as needed, but the order remains
critical. Each project will have a different list.

Thanks,
Mich

 

[Klatuu]

Rather than numbering them 1,2,3,4,5 Number them 10,20,30,40,50
Then you can easily add numbers in betwen. Avoid adding a number that is 1
more or 1 less than an existing number to allow yourself more insert options.