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

%ForEachFKColumn()

Expands the macro code for each of the foreign key columns migrated through the current relationship.

Syntax

%ForEachFKColumn() {

<macro code>

}

Syntax Example

%ForEachFKColumn() {

%AttFieldName

}

Expansion

master_number

movie_copy_number

Full Syntax

%ForEachFKColumn(<separator>) {

<macro code>

}

Full Syntax Example

%ForEachFKColumn(", ") {%AttFieldName}

Expansion

master_number, movie_copy_number

Usage

Classified as a Relationship macro. A relationship must be in scope. <separator> is optional. Can be used in RI or Rel Override, %ForEachParentRel, %ForEachChildRel.