Creating a Simple Lookup List

It is interesting how many different ways people can come up with to enter the same items of information in a database. Asked to enter the name of their home state, for example, residents of the state of Washington will type Washington, Wash, or WA, plus various typographical errors and misspellings. If you ask a dozen sales clerks to enter the name of a specific product, customer, and shipper in an invoice, it is unlikely that all of them will type the same thing. In cases like this, in which the number of correct choices is limited (to actual product name, actual customer, and actual shipper), providing the option to choose the correct answer from a list will improve your database’s consistency.

Minor inconsistencies ...

Get 2007 Microsoft® Office System Step by Step now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.