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

- 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.

- 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.