Lookup codes ensure database integrity. Lookup codes are short versions of otherwise long descriptions and therefore ensure that all users use the same codes making searches for information a lot easier.
The Lookup Codes are stored in a table in one of your settings databases and are updated with each Aquabase update. The updates update the default lookup codes only, which may be in a read-only location under your installation directory. If there are new default codes and your settings files/databases are in a non-default location (e.g. on a server or other shared location) then you can use the “Tools|Lookup Codes|Sync Lookup Codes with default codes” menu to add these to your codes.
Lookup Codes on entry forms are either selected by drop-down lookup boxes, in which you can also type the code, which automatically opens the drop-down to the relevant code, or in grids by typing the code or by right-clicking the field (while it is highlighted) and selecting the code from a list. The latter allows searching through the code or the description by clicking on the column and then starting to type.