Configure a Lookup element for each attribute field that has values to be replaced by lookup values.

A lookup element has some preconditions to be fulfilled:

a configured Database Connection necessary for accessing the database table

a configured Table with at least one search field

 

Lookup configuration

Lookup configuration

 

Property

Description

Lookup data field

Field of lookup table which contains the description values that will get displayed in the WebOffice 10.9 SP1 clients.

icon_comment

If you want to use a lookup table in order to provide language specific support, then configure the language specific attribute field of the lookup table for each respective language.

For example:

- German: Category_DE

- English: Category_EN

Field

Specifies the field the lookup is configured for.

Lookup ID field

Field of lookup table used as ID. This field is used for defining the relation (link) of the base table (layer) with the lookup table.

icon_comment

The field types of the two ID fields (layer/table and lookup table) must be the same.

Lookup sort field

Field of lookup table to be used for sorting the value list of this lookup (e.g. when editing or searching the lookup field).

icon_comment

This field is only available within these two configuration elements:

- Queries (List of lookup definitions)

- Editing (List of lookup definitions)

Sort order

Field which sets up the sorting order:

- Ascending

- Descending

icon_comment

The sorting order is done only alphabetical or numeric if the Lookup sort field is numeric. An alphanumeric sorting order is currently not supported.

This field is only available within these two configuration elements:

- Queries (List of lookup definitions)

- Editing (List of lookup definitions)

Check consistency (search)?

Specifies whether to check existence of each of the lookup values in the feature class before providing the value to the

- search form list box (Yes) (therefore, there cannot exist queries without a result) or not (No). The latter is optimum concerning performance.

- result (Yes) (if no lookup equivalent is found the result will display a blank value for the field) or to display not relatable values as IDs (No). With the latter configuration, in the case of inconsistencies between data and lookup definition, result values can sometimes show IDs in other cases lookup values.

Lookup properties

 

icon_comment

It is also possible to configure a lookup element only for a Result Field. You can use this configuration if the lookup field will not be used in any search form.

 

Lookup configuration for a result field

Lookup configuration for a result field

 

Lookup configuration for an edit layer

Lookup configuration for an edit layer

 

icon_comment

Very large value lists may lead into a problem in Internet Explorer which is caused by a general problem of Internet Explorer.

icon_cross-reference

See chapter List of Lookup Definitions for more information about lookups.

See chapter Tables for details about the configuration of tables.

See chapter Edit Layers for details about the configuration of edit layers.

See chapter DB Connections for details about the configuration of database connections.

See the HowTo chapter Configure Lookups for a detailed description of a lookup configuration.