Columns / Fields Registry entries

An overview of Columns / Fields is available in How to reference fields and columns.

Note the distinction between a column and field:

• Each field in a module is associated with a column in the table corresponding to that module, e.g. the State Province: (Address) field in the Parties module is associated with the AddPhysState column in the eparties table.
• While there is only ever one instance of a column, its associated field may display more than once in the same module, e.g. Party Type: (Party Details) displays on both the Person tab and the Organisation tab in the Parties module. If a Registry entry defines access to the column NamPartyType, it will be applied to both instances of the field Party Type: (Party Details).

Columns / Fields Registry entries include:

Column Colour Registry entry

Specify the background colour of a field when displaying records.

Column CSS Registry entry

Specify the default font family and font size for EMu client controls that display HTML formatted text (i.e. KEHTMLFrame controls).

Format Registry entry (field specific)

Image Display Registry entry

Specify an image (and sound and hint if required) to display along with Summary Data in a module window.

Insert Defaults Registry entry

Specify a set of values to display by default in a module when the module enters New mode. One or more sets of default values can be specified.

Insert Defaults Selected Registry entry

Specify which set of default values specified in an Insert Defaults Registry entry is currently active for a user / group.

Insert Defaults Skip Columns Registry entry

Specify fields that should not have a default value assigned to them in New mode.

IRNRange Registry entry

Specify a range of numbers for the Internal Record Number (IRN).

Mandatory Registry entry

Specify that a field is mandatory and must be completed before a record can be saved.

Mandatory Modifier Registry entry

Modify the mandatory setting for a field (set using the Mandatory Registry entry) based on data found in the current record.

Query Defaults Registry entry

Specify a set of values to display by default in a module when the module enters Search mode. One or more sets of default values can be specified.

Query Defaults Selected Registry entry

Specify which set of default values specified in a Query Defaults Registry entry is currently active for a user / group.

Query Defaults Skip Columns Registry entry

Specify fields that should not have a default value assigned to them in Search mode.

Reportable Registry entry

Specify whether a column can be included in a report.

Spelling Registry entry

Specify which fields to spellcheck when the EMu Spell checker is run.

Unique Registry entry

Specify that a column or a combination of columns must be unique in order to save a record, and a message to be displayed if uniqueness is violated.

Unique Override Registry entry

Specify that a user / group can save a record even if a Unique Registry entry specifies that a column or a combination of columns must be unique in order to save a record and that column or combination of columns is not unique.

Unique Strict Registry entry

Specify whether unique checks should be performed on a column that has been defined as unique on the server (in the table schema itself or using a Unique Index Registry entry). By default all unique columns are checked for uniqueness. With this entry it is possible to override the uniqueness check.