Suggestion on managing priorities in a form

[JordanR]

I'm writing a task tracking database to be used during staff meetings. Each task should be assigned a priority, and no two tasks should ever have the same priority. Easy enough.
Here's where I could use some suggestions. If I have a new task, what would be easiest way to manage that insertion (assuming it has a higher priority than the lowest item), without having to renumber all the other items in the table?

 

[ejstefl]

The only way I can think to do it would be to first test if the new record has a duplicate priority. If it did, you would need to run an update query which selected all records with the priority >= the priority in the new record, and update the priority field to priority + 1. You could then insert the new record.