Sorting tableframe on child secondary index

Hi,

I think that I am chasing a rainbow :(

I have a number of tables normally in a 1-M relation thus

Author -->> Title -->> Edition -->> Book

Now I want to generate a form to see a simple one-line listing of every
book on the database, so a dm thus

Book --> Edition --> Title --> Author

and a tableframe does the job nicely, and since I have a secondary index
on the book reference number in the master table book.db I can see them
in that order easily.

Now when I want them in Author order .... the secondary index on the
Author name is on the last table and does not show up on the interactive
Format / Filter / Order-by option.

I suppose that is how it is, just please tell me that I am not missing
something here.

-----
Anne Wainwright
Please reply to group
.