Netflix style priority Queue

[Designer]

I need a priority field for my project to do list that will only allow unique values. I just received marching orders from my client with 17 of 22 projects set to the priority "1-Extreme Rush". (I can't work with this kind of pressure!) I need something more like the rental queue in Netflix where each project is numbered from 1 to whatever the number of records is. AND that can be modified, so that if Project number 3 suddenly is needed sooner, it can be changed to number ONE and project 1 will change to 2, 2 will change to 3, but 4 and all remaining projects do not change. Any ideas anyone?

Thanks!!

[Jim McKee]

Designer ...

Check this thread. I think it might help you at least get started creating what you need.