Description	Top

Lookup pages are typically launched from SDI Maintenace pages by clicking the lookup icon next to the field. "Dynamic Lookups" offer an alternative by providing typeahead with incremental search while entering characters into a field. A field configured for Dynamic Lookup has a green border. As you type characters into the field, the incremental search list is displayed with a list of items matching the characters you have entered. You can then choose from this list:

The search is case-insensitive, and is conducted beginning with the start of a column or word (after a space character). The lookup icon is optional (as determined by the Element configuration). By default, choosing "Yes" or "Yes (hide lookup icon)" uses the KeyId1 and Description columns of the linked SDC:

The "Column Id" and column "Width" displayed in the incremental search list are configured through the "Lookup Columns" property. The "Searchable" option lets you specify whether or not a specific column participates in the typeahead search. By default, all columns are searchable.

Example:

"Searchable" set to "Yes" for InstrumentType		"Searchable" set to "No" for InstrumentType

Setting the "Mode" to "Hidden Only" hides the column such that it will not participate in the incremental search and will thus not be displayed in the search list.

"Mode" is not "Hidden Only"		"Mode" is set to "Hidden Only"

Note the data retrieval options in "Lookup URL" (such as "SDCId", "Query From", "Query Where", "Restrictive Where"):

If the column is linked to an SDC, configuring these data retrieval options is not required to retrieve the data, as the entire SDC is searched by default. However, you can use these options whether or not the column is linked to an SDC to retrieve specific data.

Note that "Query Where" and "Restrictive Where" can use values from other columns. For example, if you have a ProductId Lookup on a Sample Maintenance page, sampletypeid='[sampletypeid]' retrieves only Products related to the same Sample Type.

Behavior of the "Map to Column" property is similar to Lookup pages. For example, if "Column Id" is the Product Description column (productdesc) and "Map to Column" is the Sample Description column (sampledesc), the ProductId Dynamic Lookup fields can copy the Product Description to the Sample Description field: