Similar to the DBLOOKUP2 function, except that it returns all matching values as a comma delimited string.
Syntax
DBLOOKUPLIST2 ( SourceField1, SourceField2, "connection", "table", "lookup_field1", "lookup_field2", "substitution_field" )
| Parameter | Description |
|---|---|
| SourceField1 | The value for which to search in the lookup_field1 column. |
| SourceField2 | The value for which to search in the lookup_field2 column. |
| connection | The connection where this lookup table resides. 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. |
| lookup_field1 | The name of the column in the lookup table that stores the first value to search for. |
| lookup_field2 | The name of the column in the lookup table that stores the second value to search for. |
| substitution_field | 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.
Use this function with Lookup Links and the IN operator.
This function works only with databases or adapters that support SQL queries.
See also