Lookup Element Properties

With a Lookup element you can create and customize a search against a data source ( like SQL Server, OLEDB, ODBC or Reference Data etc). In addition:

  • You can drag and drop a Lookup element onto a cell in a Repeating Table to bind the lookup to the table cell.

  • You can drag and drop a Lookup element onto a Repeating Group to bind the lookup to that group.

Note:

Notes:

  • Provide the Filter with brackets around the connection column name, when working with Solution Data Library or Reference Data connection types.

  • The sorting and search functionality in this control works only if the corresponding data connection allows for it. For example, the Group data connection does not allow for a filter, so search does not work for it.

  • After exporting the solution, open the Set Field dialog once to see the correct field names.

  • Filter property of Lookup Control has been disabled for userfromgroup Data Connection.

Back to Form Elements

Related topic: Element Properties

Property

Description

Name

A descriptive name for the element.

Data Source

Name of the Data Connection.

Table

Name of the table in the specified data source.

Display Columns

Comma-separated list of columns to display in the pop-up selection window.

Set Fields

Comma-separated list of query return values and fields to set in the form. The format is: <Form field name>=<Column in Data Connection>, <Form field name>=<Column in Data Connection>, ….

Search Column

Name of the database column that is being queried.

Search Operator

Operator to use in the query (valid values are <, >, =, !=, <=, >=, like).

Search Key Field

Form field containing the value to use in the constructed query.

Minimum Search Key Size

Minimum character size for the query term.

Auto Wildcard End

Automatically appends a SQL wildcard character to the end of the where clause.

Auto Wildcard Start

Automatically appends a SQL wildcard character to the beginning of the where clause.

Auto Run At Start

Query runs when the form starts.

Auto Run At End

Query runs when the form is submitted.

Run When Field Changes

Returns the lookup query when a specific field is changed.

Form Run Query Only

Runs only the query portion of a Lookup element when a form field value is changed, skipping the step where another form field’s value is set. The default value is off.

Allow Multiple Selections

Allows you to select multiple listings from the returned query results when the pop-up option is selected. The default value is off.

Append To Repeating Group

Appends results to an existing repeating group. The default value is off.

Raw "Where" Clause

Allows you to specify a custom where clause for a SQL statement. If you are using Search Column, Search Operator, and Search Key Field, it will result in a where clause that includes only a single condition. If you want more conditions, you must specify a custom where clause.

Autorun Lockouts

When using multiple Lookup elements that run when a field values change, circular references can occur if one Lookup element is attempting to update a field that is being used by another Lookup element (i.e. causing an infinite loop).

The Autorun Lockout property can be set to a comma-separated list of field names that are referenced by other Lookup elements. This will enable the Lookup element to run and it will not update the fields in the comma-separated list.

Interactive

How the query data is shown.

  • Popup: Data is displayed in a pop-up window.

    • Table Title: The title to give the table within the pop-up window.

    • Window Width: The width of the pop-up window.

    • Window Height: The height of the popup window.

  • Drop Down List: Data is displayed in a specified list box element.

The properties "Auto Run At Start”, "Auto Run At End" and "Run When Field Changes” are not applicable to the "Interactive" option.

Clear Fields When Empty Return

Checking this box will cause form fields to be cleared if the query/lookup element does not find any results (data/rows) to display.

Ordinal

In case of multiple lookup elements on the same form view, the order to use when running this Lookup element.

Image URL

The URL to an image to use when displaying the Lookup element button in the form.

Image Field Association

The form field which will be replaced with the image specified in ‘Image URL’ property.