Creating Table Procedure Specifications › Define a Table Procedure Specification › Select the Target Record

Select the Target Record

The target record is the record that you ultimately want to access. Once you create a path to the target record, you can update, delete, and insert target record occurrences. In the EMPEMPT example, the target record is the EXPERTISE record. The Target Record tab is the same as the Path Record tab and appears when you select the Target button in the Entry Record or Path Record tabs.

To create a target record

1. Click the Target button in the Entry Record or Path Record tabs. Be sure you specify a unique key for the record before you click Target.
2. Quick Bridge displays the Target Fields tab. All fields in the target record appear except the unique key fields. Click Include All to include all the fields in the target record or select one or more fields and then Include.

In the following screen, the target record is EXPERTISE and the unique key for the record is SKILL-LEVEL-0425. The remaining fields in the EXPERTISE record are the target fields:

These fields are the non-unique key fields in the target record. Note that the SQL column names have been edited because the name cannot exceed 18 characters.