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

%ChildFK()

Lists the foreign key columns of the child table in a relationship, and performs the specified action on each.

Syntax

%ChildFK()

Syntax Example

%ChildFK()

Expansion

master_number, movie_copy_number, and so on

Full Syntax

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

Full Syntax Example

%ChildFK(" or ",updating,%Child)

Expansion

updating(MOVIE_RENTAL_RECOR.master_number) or

updating(MOVIE_RENTAL_RECOR.movie_copy_number)

Usage

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