Second name field - Douglas J Steele?

[Penny]

Thanks Tom, Douglas and all for your input.

Douglas, you made some suggestions a couple of days ago regarding my
questions about searching Artist names in the format 'Dylan, Bob'. 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

 

[Douglas J. Steele]

Penny: Arvin Meyer and I both answered this question for you already.

Yes, I have a sort field for each artist. One approach is to set the sort
field to the same as the Artist name (in the AfterUpdate event of the Artist
name field), but allow it to be editable.

 

[Penny]

Thanks Douglas!