Working with Data Models › Macro Toolbox › Relationship Macros › %JoinFKPK()

%JoinFKPK()

Joins the foreign key (FK) of a child entity to the primary key (PK) of the parent entity in a relationship. Returns the code supporting the comparison of FK and PK values in a relationship.

Syntax

%JoinFKPK(<child table>,<parent table>)

Syntax Example

%JoinFKPK(%Child,%Parent)

Expansion

MOVIE_RENTAL_RECOR.master_number = master_number and

MOVIE_RENTAL_RECOR.movie_copy_number = movie_copy_number

Full Syntax

%JoinFKPK(<child table>,<parent table>,<comparison op>,<separator>)

Full Syntax Example

%JoinFKPK(%Child,%Parent," <> "," or")

Expansion

MOVIE_RENTAL_RECOR.master_number <> master_number or

MOVIE_RENTAL_RECOR.movie_copy_number <> movie_copy_number

Usage

Classified as a Relationship macro that you can use in RI or Rel Override, %ForEachParentRel, %ForEach ChildRel.