CODETABLE Database Function

Use:	Displays the description for a given code and code type from the code_tables table.
Syntax:	`{CODETABLE( «code» , «type»)}`
Arguments:	`«code» Code used to find the description (code_tables.code) «type» Type of code (code_tables.code_type)` Note: Use the code type from the codes_table; do not use the code displayed in File Maintenance. You can query the code_tables in SQL Server to find the code and type in the format you need to enter.
Returns:	The description from the code_tables table.
Example:	`Fields = txt_code, txt_type {template_name_.txt_code} = M {template_name_.txt_type} = mar_status {CODETABLE( {template_name_.txt_code}, {template_name_.txt_type})}` Result: Married