Macro Toolbox › Relationship Macros › %ParentPK()

%ParentPK()

Lists the primary key elements of the parent table in a relationship, and performs the specified action on each.

Syntax

%ParentPK()

Syntax Example

%ParentPK()

Expansion

master_number, movie_copy_number,…

Full Syntax

%ParentPK(<separator>,<function>,<prefix>)

Full Syntax Example

%ParentPK(" or ",updating,%Parent)

Expansion

updating(MOVIE_COPY.master_number) or

updating(MOVIE_COPY,movie_copy_number)...

Usage

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