Code Tables
Most commercial applications involve the use of codes and their decodes in many situations. For example:
|
|
|
|
Application end-users need to be able to select a code from a displayed list of decodes, validate it using a referential integrity check and decode it to present the decode on a form or in a report
Typically codes come in relatively short lists of less than 100 items and thus end-users can select the one that they want from for example a group or radio buttons or a drop-down combo box.
However some code tables are large. For example a customer code table could store 10,000 customers. To handle large code tables you need to provide the end-user with intelligent prompting capability that allows them to quickly locate the customer they are interested in.