Database Lookup options
To maintain compatibility with previous versions,
reconfigures the GUI to the pre-6.2 configuration. This is the default.The
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
is for users who require to do a more complex query in the database.Shared options are:
-
This is unavailable, as Database Lookup only supports single-direction.
-
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.
-
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.
-
Sets the default field as a masked field.
See Table security.