Aah value lists. Reliever of the weary typist, protector of accuracy, usher to the chooser. Well concieved and implemented value lists are, despite my trifling tone, extremely useful in almost any database. In the process of rebuilding and improving an aing system recently, I was tasked with reimagining a layout with about 20 fields, each bearing a pop-up list with its own unique value list. In practice, any given record in this database had information in 5 to 8 of those 20 fields. To make the whole thing more efficient, we decided to replace all those fields and pop-ups with a single portal. We also moved the static value lists into a dynamic and more user-friendly value list table.