Identify Record Relationships

Before you create a table procedure specification, invest some time in planning and design. You need to:

Identify the record type that will become the table in the relational database; this is the target record.
Identify all the set relationships that the target record participates in. These set relationships form the foreign keys in the new table. To define the foreign keys, you must identify a hierarchy of record key fields that uniquely identify a single record occurrence for each set relationship.
Identify the network navigational path that leads to the target record. The path can be any one of the network relationships that you already identified. Good candidates include mandatory/automatic sets or a path that can be navigated efficiently. You do not need to define a path if the target record has a CALC access mode or is a member of a system-owned indexed set.