Now, what I want to do is be able to take Norm (who is in 4) and move him to the second position, have fred move to the 3rd, bob to the fourth. This would have to keep going until it reached the number that Norm was previously located in. (in this case, 4). I do not want any two people to have the same number, so I want to end up with 1,2,3,4,5 as the numbers for people in the database.
This is maybe a bit confusing, but I can't think of how I could explain it better... Please tell me if and how it can be done!