I'm trying to count the number of times a name appears in a portal. The cOccurence field in the attached example file illustrates how I'm accomplishing this. But there's a problem when a child record is moved from one row to another.
For example, here's my starting point:
And here's what it looks like after I've swapped rows 5 & 6:
I need cOccurence in the 5th portal row to now return a value of 2, and I need cOccurence in the 6th row to return 3. What is the best way to accomplish this?
Any suggestions greatly appreciated. Thanks very much--