Create or Edit a Lookup Table

Description

Create or edit a lookup table.

Access

Manage / Configuration / Lookup Tables / Insert a new item or Delete selected items

Controls

General	Description
Name	Type the name of the lookup table.
Description	Type a description of the lookup table.

Lookup	Description
	Click to insert a new record in the lookup table.
	Click to delete a selected record from the lookup table.
Local	Click in the data grid box and do one or the following: Select an existing value from the list. Type a new value.
Foreign	Click in the data grid box and type a value from the imported or exported file.

Notes

The value required depends on the lookup table type created.
Select the lookup table when importing from another system to change the Foreign value to the Local value during the import process.
Select the lookup table when exporting to another system to change the Local value to the Foreign value during the export process.
Select the lookup table in processing options to display the 'Foreign' codes when editing measurement codes.
Defaults will be used when Local values are invalid.
For layer lookup tables:
- New layers added to the Local column are created on import when required.
- You can map a blank Foreign value to a Local layer.
To prevent an attribute from being imported from or exported to another system, map the attribute name to a blank entry in the lookup table.

Possible errors

Message	Description
"Invalid entry 'Layer Name' on line [n]."	The local layer name containing a '/' is invalid. Rename the layer.