Calculating number of a fixed sort order
I need to create a field that represents the order of the entire database according to a particular sort -- regardless of how the records are actually sorted!
In other words, if I sort the records another way, or have search results showing only a few records, I don't want the field showing the original order to change.
To make matters worse, the sort order is by three fields: first "Type", which is sorted by the contents of a Value List; then "Title" and "Subtitle", which are both alphabetic. Records in each field are NOT unique, though no record has all three values the same.
Any information gratefully received, even if it's just pointers.