AnsweredAssumed Answered

Rank?

Question asked by director@charlesmoore.org on Oct 24, 2014
Latest reply on Oct 25, 2014 by FentonJones

Title

Rank?

Post

Good Morning...  I need to be able to "rank" records.  But I need these to be self adjusting.  SO if I have a series of records that are each ranked 1, 2, 3, 4, 5.  And then I create a new Record that needs to be ranked "3", then all then the Records formerly ranked 3, 4, 5, auto adjust to 4, 5, 6.  Similarly, if I decide that the Record ranked 1, now should be ranked 5, then everything adjusts, so that 2 becomes 1, etc.  Is that possible?  Any help?  

Outcomes