Publication Date: 8/17/2026 Share Print

Previous Topic

Next Topic

Book Contents

Book Index

Join Button

The Join option allows users to establish a relationship between fields in multiple tables.

Open a table. The user may select multiples tables.

Join_1

Select the Join but_join_small button to establish a relationship between the tables. Select a field from each table.

The ' = ' relationship is established by default Join_2.

Join_3

Change the relationship between the two fields by clicking on the relationship link and select a relationship from the Relationship Window.

Join_4

Select the fields from the tables that will be on the print. The Select Tab in the lower functions Window will show the selected fields. Select OK. The relationship changes from equal to ( = ) to greater than ( >).

Join_5

Select the Preview but_preview_sm button. The following table is generated. Notice the Work Order's in the column on the left are greater than (>) the Work Orders in the column on the right.

JOINOPT6

See Also

Quick Print Buttons

Clear Button

Open Query Button

Quick Select Wizard Button

Open Data Window Button

Format Button

Save Query Button

Open Table Button

Sub Query Button

Preview Button

Arguments Button

Convert To Syntax Button

Open PSR Report Button

Top of Page Publication Date: 8/17/2026 Share Print