From: info@sundialservices.com   
      
   Delbert  Liechty wrote:   
   > On an occasion or two, when I did Open Query I got two Query bars, both   
   > just   
   > alike.  What causes this, and what's the best resolution?  (This is on my   
   > mailing label database, Paradox 8, Windows 98SE.)   
      
   I don't quite know what you mean by "double query bars," but I can guess...   
      
   A query can involve more than one table at a time.  For example, a query   
   about "Orders" might also involve a table of "Customers."  And if you look   
   closely, you'll notice that the two tables are "linked" in some way using   
   so-called "example elements."  For instance, the query that I'm describing   
   would most-likely link the two tables by, say, "CustID."   
      
   The reason why you might want to do that should, actually, be pretty   
   obvious:  you want to get information about each customer.  The "Orders"   
   table does not repeat the information about the customer:  it only contains   
   the "CustID."  So the query will retrieve "whatever you want to know about   
   this customer" from the "Customers" table.  This is a key concept of   
   a "relational" database.   
      
      
   ----   
   ChimneySweep(R): Fast(!) table repair at a click of the mouse!   
   http://www.sundialservices.com   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)