|
|
|
|
|
Displays the display name of the primary table. The table's name also will appear at the top of the Primary Table portion of the Relationship scrolling window.
Displays the name of the table related to the primary table. To select a new table, click the Secondary Table lookup button to open the Relationship Table Lookup window. Select the name of the table you want to use as the secondary table and click OK. That table's name will appear in this field and at the top of the Secondary Table column of the Relationship scrolling window.
Displays the key containing the field or fields that you want this table relationship to be based on. Once the key is selected, each of its key segments is listed in the Secondary Table column of the Relationship scrolling window.
|
If you are defining a one-to-many relationship, selecting a key that places records from the secondary table in the desired order will optimize performance. |
For at least the first of the secondary table's key segments, select a related field from the corresponding drop-down list in the Primary Table portion of the Relationships scrolling window. The drop-down list contains only fields from the primary table that have compatible data types as the corresponding key segment in the secondary table. For example, if the key segment 'course' is a STR30 data type, only fields in the primary table that are compatible with the STR30 data type will appear in the drop-down list.
If the key contains multiple segments, you need not select a corresponding primary table field for each key segment. However, the key segments you do select corresponding fields for must be consecutive key segments. For example, if a key has four segments, you could select corresponding fields for the first two segments, but not for the first and third segments only.
To change the primary table field you've selected, simply choose a different field from the drop-down list.
If the secondary table's key on which this relationship is based allows duplicates, the relationship will be one-to-many, and Multiple Records will appear in this field.
If the selected secondary table's key doesn't allow duplicates, and you select a corresponding field for each key segment, the relationship type will be one-to-one, and One Record will appear in this field. If you select a corresponding field for only some of the key segments, the relationship type will be one-to-many, and Multiple Records will appear in this field.