Select Join Table Dialog

The Select Join Table dialog lists tables in the Source File that are related to the table selected on the Comma Separated tab.

Select Join Table dialog
Table
Name of the table to which you want to join one or more related tables.
Join to Table
Lists tables in the Source File related to the current table.
Number of Relationships
Lists the number of relationships between the related table and the current table.

Select one or more table names from the list and click OK. If a single relationship between the tables exists, the table is joined automatically.

Note: If only one relationship exists between the current table and an eligible join table, you can select Open Relationship from the shortcut menu to open the Relationship Editor. If you select a join table with more than one relationship, you can select Open Relationship from the shortcut menu on the Select a Join Relationship dialog to open the Relationship Editor. For more information see n the Common Elements Manual.

Specify a Relationship for Joining

If more than one relationship for a table exists for a table you want to join, you must choose a relationship from the list on the Select a Join Relationship dialog.

Select a Join Relationship dialog
Join From
Name of the table to which you want to join a related table.
Join To
Name of the table selected in the Join Table dialog.
Relationship Name
The fully qualified name for a relationship consists of the following:
dbalias
Alias of the database where the child table is defined (1 to 12 characters).
creatorid
Creator ID assigned to the child table (1 to 64 characters).
tablename
Name of the child table (1 to 64 characters).
constraint
Name assigned to the relationship (1 to 64 characters).
Type
Indicates whether the relationship is generic, explicit (Optim™), or defined to a specific DBMS.
Usage
Indicates whether the relationship was used to extract rows during the Archive or Extract Process:
Used
Relationship was used to extract rows.
Ref
The Join From or Join To table is a Reference Table, and the relationship was not used to extract rows.
Unsel
The relationship was deselected in the Access Definition, so the relationship was not used to extract rows.
Index Exists
Indicates that this relationship has been used to join the Join From and Join To tables during a Browse session.

When a relationship is used to join tables during a Browse session, an index is created. This index stores primary key and foreign key information to expedite the retrieval of data.

Note: You can select Open Relationship from the shortcut menu to open the Relationship Editor. For more information, see the Common Elements Manual.