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

Task

Retrieve a list of foreign key fields in the link record (Record From ID) 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 = ‘M’
AND LINK IMPLEMENTATON_ID = IMP.ID
AND FLK.LINKAGE_ID = LINK.ID;

To get the full picture, this join should be used for the implementation of each of the inverse relationship memberships in the many-to-many relationship.