Previous Topic: Sample 2: Target Record Member of a Set RelationshipNext Topic: Sample 4: Target Record Part of a Bill-of-Materials Relationship

Table Procedure Examples, Design, and Use › Samples from the Commonweather Database › Sample 3: Target Record with No Unique Key

Sample 3: Target Record with No Unique Key

Target Record

EXPERTISE (no unique key)

Set Relationships

EMP-EXPERTISE (owner EMPLOYEE, CALC key EMP-ID-0415)
SKILL-EXPERTISE (owner SKILL, CALC key SKILL-ID-0455)

Path

EMPLOYEE, EXPERTISE

Analysis

The EXPERTISE record type does not have a field that can uniquely identify a single occurrence. Both set relationships are mandatory/automatic, but because the EXPERTISE record type is stored VIA the EMP-EXPERTISE set, it makes more sense to choose that relationship, making the owner record, EMPLOYEE, the entry record in the primary path.

To define the table procedure specification

  1. In the Entry Record tab, select Employee and EMP_ID_0415 as the unique key field. Click Next.
  2. In the Path Record tab, select EXPERTISE. Click Target.
  3. In the Auxiliary Record tab, select SKILL-ID-0455 as the unique key for the SKILL record.
  4. In the Target Fields tab, select the appropriate columns and then save and generate the table procedure