Enviro Data uses lookup tables to enforce data consistency, expand codes, and save storage space. These tables are sometimes called Valid Value Lists. Lookups include Station Types, Matrix, Parameters, Units, and many more. Some you will use, and others you may not need. Before starting with a new project you might want to modify the contents of the lookup tables  to suit your project needs. When you create a new database, the lookup tables are brought into the new database from the database you are currently attached to. For your first database, the lookup tables will be from the sample database provided with the software (EnvDData8.mdb).

You can view the existing lookup values, and modify them as necessary. As you create more databases for different types of projects, these lookup tables can evolve. For each new database, you should use an existing database that will have the most similar lookup table contents, and use that to create the new one.

1. Click Maintain Database in the Setup section of the EDITOR MENU.

2. Click on Lookups Report, and print it if you wish. Then close the report, and the MAINTAIN DATABASE form.

3. On the EDITOR, again  under the Setup section, click on Manage Lookups. This screen shows the lookup tables that you can edit.

4. Click on one of the buttons, such as Sample Matrix, to open the editing form. Modify the values as necessary, and then close the form.

Note that in order to maintain referential integrity in your database, you cannot modify any lookup code that is in use in another table. You are able to modify lookup's description however. For example, is the lookup for Sample Martix has a code of "u" for "Ground Water" is used for an analyese, you cannot change the "u" but you could change the description to "Groundwater" if you so chose.