Database Lookup options

To maintain compatibility with previous versions, Table Lookup reconfigures the GUI to the pre-6.2 configuration. This is the default.

The Basic Database Lookup option is suitable for users who require to look up data from the In field in a database table. It is also used to view and return the matched value in the Out field.

Selecting Advanced Database Lookup is for users who require to do a more complex query in the database.

Shared options are:

  • Bi-directional

    This is unavailable, as Database Lookup only supports single-direction.

  • Use Original Value

    If the lookup fails, this options keeps the original value of the field being loaded from the lookup. This option is unavailable if you have defined multiple In columns.

  • Use Default Value

    Select this to use what is defined in the field. Specify a default string to use for data conversion if an input data value is not in the lookup table.

  • Set Default Value as Masked Field

    Sets the default field as a masked field.

    See Table security.