Last Name, First Name between books and music

[Robby Stephenson]

Hi,

On Thursday 07 December 2006 14:04, King, Darren wrote:
> In my book collection, when I enter an author's name, it sorts them by
> last name for me even if I enter them in the common manner

Just so I'm sure we're on the same page. The name and title formatting can 
be turned off globally in the settings. You can also change the Author 
field to simply auto-capitalize instead of formatting as a name. That has 
the side-effect of not showing up in the <people> group, but that might not 
bother you. So with those two options...

> However, in my CD collection artists are listed alphabetically by their
> First name so George Jones would be listed that way and be in the G's.
> This isn't what I want, I want it to be like books where I can type in
> George Jones but it gets listed by artist as Jones, George.

You could change the artist field to format as a name. But as you point out, 
that will give you Skynyrd, Lynyrd.

Currently, there's no way to specify the formatting on an individual basis. 
Every value for the field gets formatted the same, either as a name, title, 
or neither.

I'm going to be trying to build in that sort of flexibility in the SQL 
database, separating people from groups, so to speak. Not sure how that'll 
work out, but I'm trying to keep it in mind, among other things.

Robby