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.
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.
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. |