DB Lookup looks up values in a database. The lookup data is specified by the result set of a query returning exactly two columns – the lookup key and the lookup value.
You can assign the return value (lookup value) by the lookup to any attribute of the current record. DB Lookup caches the lookup table during project execution. Changes applied to the underlying database during project execution have no effect on the lookup result.
