Code Tables

Code Tables

Most commercial applications involve the use of codes and their decodes in many situations. For example:

Country Code Country Decode 1 North America 61 Australia 44 Great Britain 31 Netherlands 64 New Zealand 65 Singapore 81 Japan

 

Currency Code Country Decode USD US Dollar GBP Great Britain Pound AUD Australia Dollar JPY Japanese Yen

 

Sex Code Sex Decode M Male F Female U Unspecified

 

Document Code Document Decode DOC MS-Word Document PPT MS-PowerPoint Document RTF Rich Text Document TXT Text Document

   

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.  

• Framework Code Tables

• Code Table Data Flow

• Setting up a Code Table

• Using a Code Table in your application

• Advanced options when setting up a code table

• Frequently asked Questions about Code Tables

• Using Assistants to handle more complex "codes"