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

%SetFK()

Lists foreign key attribute names of a child entity in a relationship and sets each member to the specified value.

Syntax

%SetFK(<child table>,<value>)

Syntax Example

%SetFK(%Child,NULL)

Expansion

MOVIE_RENTAL_RECOR.master_number = NULL,

MOVIE_RENTAL_RECOR.movie_copy_number = NULL

Usage

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