Sorting compound names // mistake!

[jda]

>On 9/22/04 4:23 PM, "jda" <jda at his.com> wrote:
>
>>  The authors field of *one* record might be
>>
>>  Zasukhin, R
>>  Brenstein, R
>>  von Abel, GE
>
>Jon,
>
>This is bad design of database!
>
>You must have separate table "Authors".
>You must split above one record into 3 records of that table.
>
>This is MUST TO DO !!!
>
>
>I can image this make your life more complex, but it is correct way.
>
>         Author : Books  is   M : M
>
>Btw, this is excellent case for new Valentina's feature BinaryLink.
>

Perhaps, but too late to change it now! I chose to make a flat file 
database rather than a relational one years ago, and it works well 
for my purposes. If I were starting from scratch perhaps I would do 
things differently, but...

Jon