Lookup Table Dialog Box

This dialog box is displayed after entering or selecting a table name in the Tables/Lookup/New command or the Tables/Lookup/Open command.

The dialog box is used to edit the lookup table created or selected.

Item	Used to
Local	Key in or edit feature codes that are contained in the code table and are to be matched to the corresponding code in the Foreign column when importing data to the system. Maximum of 8 alphanumeric characters.
Foreign	Key in or edit feature codes that are contained in the data set that is to be imported into the system, and are to be matched to the corresponding code in the Local column. Maximum of 255 alphanumeric characters.
Insert:	Insert a blank line at the cursor position therefore allowing creation of a new code pair.
Delete:	Delete the code pair at the current cursor position.
Save:	Save any changes made.
Exit:	Close the dialog box and allow you the option of saving any previously unsaved changes.

When data is imported into the system, the lookup table may be used to match feature codes in the incoming data set to feature codes in the selected code table. Refer to the Lookup Table topic for a more detailed description of the benefits and uses of lookup tables.

The Lookup table dialog box contains two columns of codes. The codes in the first column are feature codes to be used in the system and should exist in the Code Table that you intend using with this particular lookup table. The codes in the second column (i.e. foreign) are codes used by a third party and exist in a data file which is to be imported into the system.

For each line in the lookup table the foreign code is matched to the Local code during the importing operation.