Previous Topic: Samples from the Commonweather DatabaseNext Topic: Sample 2: Target Record Member of a Set Relationship

Table Procedure Examples, Design, and Use › Samples from the Commonweather Database › Sample 1: Target Record Accessible by CALC key

Sample 1: Target Record Accessible by CALC key

Target Record

EMPLOYEE (unique key EMP-ID-0415, the CALC key)

Set Relationships

EPT-EMPLOYEE (owner DEPARTMENT, CALC key DEPT-ID-0410)
OFFICE-EMPLOYEE (owner OFFICE, CALC key OFFICE-CODE-0450)

Analysis

Occurrences of the EMPLOYEE record can be uniquely identified using its CALC key.

To define the table procedure specification

  1. After completing the OPTIONS tab, select the EMPLOYEE record type in the Entry Record Name drop down box. Select EMP-ID-0415 as the unique key for this record type and click Target.

    Quick Bridge finds all set relationships for the target record and creates Auxiliary (Aux) tabs for the DEPT‑EMPLOYEE and the OFFICE‑EMPLOYEE relationships, as well as a tab for the Target Fields and another for Additional Columns.

  2. In the Target Fields tab, select all fields you want in the new table. For all but the rare case (field REDEFINES, for example), click Include ALL to include all record fields as table columns. You can create a table view later if you do not want specific columns displayed.
  3. The Aux tabs represent the network relationships that will become foreign keys for the new table. For the DEPT‑EMPLOYEE Aux tab, choose DEPT‑ID‑0410 as the unique key. For the OFFICE‑EMPLOYEE Aux tab, choose OFFICE‑CODE‑0450 as the unique key. Save and generate the new table procedure.