I'm pretty sure this question has been asked before!! but here goes
I want to sort my database by last name first, but to show first name first, like so
Sort by
Jackson, Al
Jackson, Janet
Jackson, Joe
Jackson, Michael
To show in left hand tree
Al Jackson
Janet Jackson
Joe Jackson
Michael Jackson
When I try to do this Michael Jackson is sorted under M
Hope this makes sense