Field Link Designer

From Appmethod Topics
Jump to: navigation, search

Go Up to Database Dialog Boxes

Use this dialog box to establish a master-detail relationship between two tables.

Item Description

Available Indexes

(Not displayed for tables on a database server.) Shows the currently selected index used to join the tables. Unless you specify a different index name in the table's IndexName property, the default index used for the link is the primary index for the table. Other available indexes defined on the table can be selected from the drop-down list.

Detail Fields

Lists the details fields in the table.

Add

Adds the selected detail and master fields to the Joined Fields box.

Master Fields

Lists the master fields in the table.

Joined Fields

Displays the selected master and detail fields.

Delete

Removes the selected line from the Joined Fields box.

Clear

Removes all of the lines in the Joined Fields box..