Rn Descriptor

The Rn_Descriptor is a special field which describes the user friendly version of the table_name_id field using a table level formula. For a new table the default is to contain the decimal version of the table_name_id field. It is very common to alter to best suit your needs.

The Rn_Descriptor is shown in several places:
 * In Rich Client, name of form when displaying a already saved record
 * In Windows Client displayed by default as the form title.
 * When selecting a parent record (e.g. defining the Company for a Contact) within all versions


 * It is advisable not to get too complicated with these formulas.
 * You can use parent or child information in the formulas, but remember they will not get updated in the database until this record is saved
 * It is wise to trim (using Left as the Rn_Descriptor field is limited to 80 characters, by default

Default Company Table left([Company_Name]), 60) + ", " + [City]