From: duffaddress@ananzi.co.za.invalid   
      
   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   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)