lookup
Returns a value from a table using primary key values.
Syntax
lookup(result lookup field, primary key field 1, primary key value 1, primary key field 2, primary key value 2, ....., default value)Parameters
- rlf : result lookup field
- pkfN : primary key field N
- pkvN : primary key value N
- default :
Description
lookup fetches a value from a table using primary key values (pkv). The first parameter is the field value to be returned, while the remaining parameters are the table primary-key fields (pkf) and their respective values. The last parameter takes in the default value, which could be through a presentation variable.