Second sort field for Artist Names - Douglas?

[Penny]

Thanks Tom, Douglas and all for your input.

Douglas, my design is a many to many as Tom suggested but I'm particularly
interested in your comment:

"What I do is store the name of the artist as a single field, plus also
store
a sort field (so that Led Zeppelin is sorted as Led Zeppelin, while Elton
John is sorted as John, Elton). I have no idea how you'd sort Henry Bob
Canola and the Canadian Harvest Symphony Metal Heads though!"

Do you have a 'sort field' for EVERY artist? Could I impose upon you to
elaborate on your extra field and how its used?

Regards,

Penny

 

[Arvin Meyer]

"What I do is store the name of the artist as a single field, plus also
store
a sort field (so that Led Zeppelin is sorted as Led Zeppelin, while Elton
John is sorted as John, Elton). I have no idea how you'd sort Henry Bob
Canola and the Canadian Harvest Symphony Metal Heads though!"

Do you have a 'sort field' for EVERY artist? Could I impose upon you to
elaborate on your extra field and how its used?

Assuming you want to sort any values differently than the value actually
stored, you must add a value to the sort field for every record. As you have
pointed out, because of the complexity of some of the artist's names, there
really isn't any single value that can be applied to the sort. How would you
want to order the Canadian Harvest Symphony Metal Heads?
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

 

[Douglas J. Steele]

Arvin's comments are bang on.