Public Interface Export Function › Internal Design Objects › Access and Connection Objects › REL_PART_IMPL (Relationship or Partition Implementation) › Task

Task

Select a list of foreign key fields in the from record and the corresponding target field (part of the primary key) of the to record.

SELECT IMP.ID, LINK.ID, LINK.RECORD_FROM_ID, FLK.FIELD_FROM_ID,
  LINK.RECORD_TO_ID, FLK.FIELD_TO_ID
  FROM
  REL_PART_IMPL IMP,
  LINKAGE LINK,
  FLD_LINK_USE FLK
  WHERE
  IMP.TECHNIQUE = 'F'
  AND LINK.IMPLEMENTATON_ID = IMP.ID
  AND FLK.LINKAGE_ID = LINK.ID;

The entry point technique implements the inverse of a foreign key technique implementation. The foreign key fields used in the foreign key technique implementation become the high order part of some entry point. This allows for efficient joins following the relationship in either direction.