Description
Use this function to lookup a source value and return the corresponding target cross-reference value. Similar to the DBLOOKUP function, except that XREFLOOKUP returns an error if more than one row is found during the lookup.
Syntax
XREFLOOKUP ( sourceKeyValue, "connection", "table", "sourceKeyField", "targetKeyField" )
| Parameter | Description |
|---|---|
| sourceKeyValue | The value for which to search in the SourceKeyField column. |
| connection | The name of the connection for this lookup table. If the connection is Scribe Internal Database, the SCRIBE user must have at least SELECT privileges on the lookup table. |
| table | The name of the lookup table. |
| sourceKeyField | The name of the column in the lookup table that stores the value to search for. |
| targetKeyField | The name of the column in the lookup table that stores the value to return. |
Remarks
Note: This function requires special handling when working with bulk operations. See Using Bulk Operations for more information.
See also