When you link two tables one table is the parent table and the other table(s) is called the child table. In our example the "cruise.dbf" is the parent table and the "group.dbf" is the child table.

Another important factor to remember is that your two tables must have a common field.

2. In the query menu, click add table (This will then allow you to select the second table to be queried.

3. Click on the icon to the left of "Cruise.dbf" and drag it down to "group.dbf".

4. Click on the "Okay" button. (Notice the double headed arrow).

5. Select the data you want to view by checking the appropriate fields. (By doing this, we have just created a "One - to - Many" relationship between the clients table and the projects table.)

6. Now lets run the query.

Now lets do some altering, using the program editor.
Simple Query
Home

© Copyright 1999 Kelly Gatt All Rights Reserved.
All information given here was written by Kelly Gatt unless otherwise stated.
All authors have been given credit in the references page.