Any chance of including sort order of names by last names first?
I was going to tell you how easy this is to do with an MC expression based field. Then I tried it. It's really easy. But it gives you the wrong results in many cases. Because this is harder than I thought, and maybe harder than you thought.
The simple expression that sorts by last name works great for John Coltrane. Sorts in the Cs. ...and for Paul Simon; sorts in the Ss. But what about Oingo Boingo? Sorts in the Bs, which is wrong. Name any two word band name and it will sort wrong. Pink Floyd doesn't belong in the Fs. It should sort in the Ps.
So how is MC to know which names are person names, and which ones are band names, which don't need to be sorted by last word? It requires user intervention to make those decisions. You could build a check box field to make this easy for the end user. Check this box to make it sort by swapped artist name. I could whip up an expression in a few minutes to do it. But it requires work for the end user.
Just some thoughts.
Brian.