Creating Drop-Downs

Navigation:  Importing (General Concepts) >

Creating Drop-Downs

Previous pageReturn to chapter overviewNext page

Drop-downs are used to encourage (or enforce) consistency in data entry.  There are three main ways in which drop-downs are populated:


Entry of a list of valid values as a validation rule (Access) or a Check Constraint (SQL Server).

Use of a Foreign Key to a lookup list

Use of the zRef_Drop_Downs table.


The zRef_Drop_Downs table is the most versitile for average users.  A user simply needs to right click on a value in ESdat and select "Add to zRef_Drop_Downs" and a drop-down for this table/column is created.