A script-enabled browser is required for this page to function properly.

Creating a simple relationship (Query Builder)

To create a relationship using the mouse:

  1. In the Query window, open the tables you want to relate.
  2. While the table is displayed, select the column (either select the check box next to the column, or double-click the column name) that you want to relate (the foreign key).
  3. While holding down the mouse button, drag the cursor to the related column in the second table (the primary key) to draw a relationship line.
  4. Once the target column is highlighted, release the mouse button to anchor the relationship line. By default, the relationship is inactive (the line appears gray).

To create a relationship using the Set Relationship dialog box:

  1. Click the Set Table Relationship button in the Icon Bar to display the Set Relationship dialog box
  2. Type the origin (A->) and target (->B) column names. Note:  You must type the complete table and column names (separate the table name from its column name with a period).  A-> represents the table's foreign key(s), and ->B represents the table's primary key(s).  Separate additional primary and foreign keys with commas.

    Query Builder draws a relationship line between the two columns.
  3. Click Close.

To create a relationship using a shortcut:

  1. Click the Set Table Relationship button in the Icon Bar to display the Set Relationship dialog box
  2. Click inside field A.
  3. In the Query window, select the column (either select the check box next to the column, or double-click the column name) . Query Builder automatically places the table and column name in field A.
  4. Repeat the procedure for field B.

See also

About Query Builder relationships

 

Activating and deactivating a relationship (Query Builder)

 

Creating a composite relationship (Query Builder)

 

Creating a self-relationship (Query Builder)

 

Creating an unmatched relationship (Query Builder)

 

Deleting a relationship (Query Builder)