From: liz@paradoxcommunity.com   
      
   The ! should only go on the _join# element in the table that *does* have   
   all the records you want, not in the table that's missing records.  So:   
      
   CUSTOMER.DB | CustomerID | CustomerName |   
                | _join1!    | Check        |   
      
   ORDER.DB | OrderID | CustomerID |   
             | Check   | _join1     |   
      
      
   ...will get me all of the customers and for those which happen to have   
   orders, it will get me all their order ID values as well.   
      
   Liz   
      
      
   Tony McGuire wrote:   
   > Use an exclamation point (!) on the joins used to link it to the other   
   > table(s).   
   >   
   > But you can only use it once, so you have to use multiple join variables   
   > (_join#) to link them all together.   
   >   
   > You can use _join1, _join15! as a part of the linking process.   
   >   
   >   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)