### Title

Self-Adjusting Rank?

### Post

Is there anyway to create "self-adjusting ranking" for records? For instance:

uniqueID = 100 "Orange" Rank = 2

uniqueID = 101 "Apple" Rank = 1

uniqueID = 102 "Pear" Rank = 3

So if one were to change: uniqueID = 100 "Orange" Rank = 1

Then, automatically

uniqueID = 100 "Orange" Rank = 1

uniqueID = 101 "Apple" Rank = 2

uniqueID = 102 "Pear" Rank = 3

Or

If one were then to add a new record: uniqueID = 103 "Pineapple" Rank = 2

Then

uniqueID = 100 "Orange" Rank = 1

uniqueID = 101 "Apple" Rank = 3

uniqueID = 102 "Pear" Rank = 4

unique=ID = 103 "Pineapple" Rank = 2

Also, if one were to delete a record, such as "Pineapple" from above, then:

uniqueID = 100 "Orange" Rank = 1

uniqueID = 101 "Apple" Rank = 2

uniqueID = 102 "Pear" Rank = 3

If possible, I would prefer this to accomplished with a calculation field rather than a script or a sorting function.

"Rank" implies sorting your records in ascending or descending order on a particular field. When I examine your examples, I cannot deduce what value in a field is being used for that sort to determine the Rank value. I thought you might be sorting on the value of Rank itself but then your examples contradict this in your last two examples:

So what field is determining the order that you then want to show as a "Rank" in the Rank field?