lookup

Type
Relational Operator

Purpose
The lookup operator selects the first record in a related table that matches the current record being processed and returns a specified field.

Syntax
lookup TABLENAME | RELATIONSHIP FIELDNAME

Returns:
The specified field value from the first matching record in the related table. The type of value returned is the same as that of the specified field.

Usage:
Example
lookup FAMILYMEMBERS FirstName