If you delete the host file, all cross-referenced files are automatically deleted.

You can also select the Join connector line and click the Delete button on the toolbar.

The files remain in the window with no connector line between them.

To create your own Join (after deleting the existing Join, if necessary):

A Join connector line appears.

• You can multi-select fields in the host file to join to a single field in the cross-referenced file when both are FOCUS files. For other file types (for example, EDA, Oracle, DB2, and so on) you must join a host field to a cross-referenced field, one pair at a time.
• For non-FOCUS joins, you can join a maximum of 63 fields from each file.

You can leave the Join editor window open and create another Join by:

• Clicking the New Join button.

  or

• Choosing New Join from the File menu.

You can define up to 63 concurrent Joins.

By default, each Join has multiple instances (that is, is non-unique). To create a single instance (unique) Join:

A default name is automatically assigned to each Join.

You can use the Join name to later clear the Join and to prevent another Join from overwriting it. If you remove the Join name completely, any subsequent unnamed Join will overwrite this Join.