It is possible to specify a List of lookup definitions for each of the Layer or Table configuration elements.

Layer / Table - List of lookup definitions configuration
Note: Assure to check the
•Database connection,
•Table,
•Search field
Required for Lookup functionality.
Note that field names of Table fields all need to be configured case sensitive!
Note: Note that in the Lookup configuration the "Lookup ID field" and the "Lookup data field" must not be identical!

"Lookup ID Field" and "Lookup Data Field" must not be identical
See chapters Query Builder Field List/Search Field List and Tables for details.