A Relational Database Lookup button has the following properties:

Anchor

To change the anchor settings click the arrow next to the list and click the positions where you want to place the anchor. The property is visible only for elements that are located on the validation form and not for the folder pane on the validation form. The value for this option is set to Top, Left by default.

Database Lookup

Properties for configuring the database lookup.

Data Source Type

Select None, Locator Alternatives, Fuzzy Database, Associative Search Database, or Relational Database.

Data Source

Select the data source from the list.

Dialog Caption

Set the caption of the search results window that displays when the database lookup button is clicked.

When you click the button to the right, the Translations window is displayed, where you can define different translations for the caption.

List Caption

Set the label that is displayed at the top of the search results window to provide guidance to Validation users.

When you click the button to the right, the Translations window is displayed, where you can define different translations for the caption.

Maximum Results

Restrict the number of records that are displayed.

Configurable Wildcards

Select whether a wildcard is automatically added to the search text.

• None. The search term need to match a record exactly for it to be returned.
• First. The wildcard is before a search string. For example, searching for im in a name field returns Jim,Kim,Tim, and so on.
• Last. The wildcard is at the end of the string. For example, searching for Ti in a name field returns Tim,Timothy,Time, and so on.
• Both. A wildcard is placed before and after the search string. For example, searching for im in a name field returns Jim,Kim,Kimberly,Tim,Timothy, and so on.

Table Mapping

When this option is set to True, table cells only are available in the Field Mapping window. When this option is set to false, simple fields only are available in the Field Mapping window.

If you are using a table, this option enables users to select multiple rows in the relational database lookup results window during production. The multiple rows are copied to the table field, appending new rows as needed. The value for this option is set to False by default.

Tip If you set this option to True, add instructions to the Dialog Capture string so that your users know that this feature is possible.

Field Mappings

Map the Destination Fields on the document with the Sources fields from the data source in the Field Mappings window.

Column Headers

Click on the button to the right to open the Column Headers window so that you can provide column titles and their localizations for your database lookup.

Field Visibility

Select what data source fields are visible in the search results window, including what field is the default search field. If the selection here does not match the fields selected for Immediate Search, this means that there may be a difference in the Immediate Search results and any manual searches performed in the Database Lookup window.

Location

The x and y values for the location of a field on the validation form in pixels. You can change the position of the button on the validation form by selecting it and dragging it to the desired position.

Name

A default name for the button is automatically provided such as Button0. You can change the name by editing the text field. This value is used when referencing the button in script.

Right-to-Left

Toggle the direction that text is displayed. Set this property to TRUE if you are using a language that is written from right to the left. The value for this option is set to FALSE by default.

Shortcut

A function key (F5 - F12) or any combination of a function key with the Shift or Ctrl key for quick access to the button functionality.

Important These function shortcuts are not supported when using Thin Client Validation. However, the modal keyboard shortcuts that are part of Thin Client Validation are still available. Press Ctrl in Thin Client Validation to get a list of available keyboard shortcuts.

Size

The width and height of a button or field in pixels. You can change the size of the button on the validation form. Select the button and resize it as needed.

Text

Edit the text to change the button caption. For example, Search.

When you click the button to the right, the Translations window is displayed, where you can define different translations for the caption.