Returns a value from a table using primary key values.


lookup(result lookup field, primary key field 1, primary key value 1, primary key field 2, primary key value 2, ....., default value)


  • rlf : result lookup field
  • pkfN : primary key field N
  • pkvN : primary key value N
  • default :


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.

See Also

© Incorta, Inc. All Rights Reserved.