Thank you for your post.
Looking over the Music Library quickly, I don't see any repeating fields, so you may have added that. A repeating field is a single field that holds many values. When you sort by a repeating field, only the first repeating value is used.
"rating1" and "rating2" come from the global field g_Sortby. If it is blank the first time, the ELSE portion of the script sets the value.
Yes, you can also set this up for your CurrentRating field. Just model a script after the SortTitle script, and attach a button to the column heading that executes the script.
Looking over the Music Library quickly, I don't see any repeating fields
I am guessing Qappl is using version 9 or lower. Many (perhaps all) templates used repeating fields instead of a related table, causing endless frustration among beginners.
GREAT SUCCESS!! I see where I was going wrong now. Where you said "rating1" and "rating2" were determined by the ELSE statement in the script was the spark. Basically, I thought I had set up my CurrentRating script the same... but I didn't see that rating2 could have the attribute of other field sorts within that same list view. When I changed that, it all worked. Thanks a bunch! Now I won't get fired.
Aaaah, who cares? ; )
BTW, using FMP 10.