Most applications use a number of code tables.
A code table is a list of values used in a set field. The list will usually be static but can be dynamic. An example of a code table would be the tblRatings table.
Coming up with a method for handling them is helpful so that when a new one is added, minimal work needs to be done.
A generic code table editor is probably one of the most simplistic of the techniques shown in this book. All it consists of is one main form and whatever subforms are needed for the various code tables. Figure 28.8 shows the main form, with the tblCategories codes displayed in the subform.
The main form used for this ...