It is possible to specify a List of Lookup Definitions for

•a layer or table query element

•a result field only

•an edit layer

Configuring a list of lookup definitions at the layer/table query level, will make sure that the lookup table will both be used for search fields and for result fields. If you configure a lookup element only for a Result Field the lookup field will not be used in any search form. Define a list of lookup definitions on Edit Layers level in order to use lookups for editing.

 

 

 

 

Consider lookups if you want to provide

•support for language specific attributes/fields:
Example: your project supports both English and German language and you got an attribute field Category with values fire department, police and emergency ambulance. If your project is started with the German interface (by adding the parameter &language=de) you want to have the german expressions for these values.

•unique value lists for populating search forms with minimal database usage:
Example: you have a big address table with fields post code, street and house number, you would need to search the whole address table for providing a list of post codes. If you instead use a lookup table for providing the list of post codes you need to search the small lookup table with unique values only.

 

Right-click to add one ore more lookup elements to the list of lookup definitions.