I want to use SharePoint 2007 to prioritise a list of projects.
Each project must have a field that specifies unique priority of the project, relative to other projects. So if I have 5 projects, they will have priorities from 1 to 5. AND if I change proirity of a project - it should update priorities of other projects.
Suppose I have 5 projects: A B C D E F with priorities 1 2 3 4 5 (1 is the most important):
12345
ABCDE
if I change priority of project D from 4 to 2, then new arrangment should be:
12345
ADBCE
D's priority became 2, B's priority changed from 2 to 3.
Is it possible to do this?
If it is a event , what is the logic applied?