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 displays on both the Person tab and the Organization 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.
More details here.
Columns / Fields Registry entries include:
Specify the background colour of a field when displaying records.
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)
Specify two separate features on a per field basis: case-conversion and uniqueness checking and auto-incrementation. A field may use one or the other feature, not both. Which functionality is invoked depends on the format string entered.
Note: Be aware that this field-specific Registry entry is distinct from the Format Registry entry (System-wide), which is for setting global formats on latitude and longitude, date and time fields.
Format Registry entry (system-wide)
Specify System-wide formats on date, time and latitude and longitude fields. Registry entries are:
- Format|Circa
- Format|Circa|Ranges
- Format|Date Input
- Format|Date Output
- Format|Time Output
- Format|Latitude Output
- Format|Longitude Output
Note: This System-wide Registry entry differs from the Format Registry entry (field specific), which specifies two separate features on a per field basis: case-conversion and auto-incrementation.
Specify an image to display alongside Summary Data in a module window, and (in EMu 9.0 onwards) in a column in List View.
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.
Specify a range of numbers for the Internal Record Number (IRN).
Customize a field's label in the client User Interface.
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.
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.
Specify whether a column can be included in a report.
Specify which fields to spellcheck when the EMu Spell checker is run.
Specify an alternative display name for a field when records are displayed in List View and for column headings in a table in Details View.
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.
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.
Feedback
