Domain Fields (Numeric Domains)

The Domain type field specification overlay, shown in Figure 2-4-16, displays after you select enter from the fields screen if the Field Type you select is DOMAIN and the domain type is numeric.

Figure 2-4-16. Domain Field Specification Overlay (Numeric Domain)

The following fields are contained on the Domain-Type Field Specifications overlay for numeric Domains:

·    Domain Name links a domain-type field to a specific domain in the same or another APPX application.

·    Descriptive provides a longer, more easily understood alternative to Field Name, one that is not required to be unique within an application. If blank at all default levels, Field Name is used.

·    Column Hdgs designates up to two lines of column heading text. The APPX output process facility uses this text to generate standard column heading images for Start of Page and Start of Range class frames. For cosmetic reasons, the length of headings should not exceed the length of a field itself. Refer to Standard Column Heading Image for additional information.

·    Auto Seq? Select "yes" if this numeric field represents a sequence number with a value that should be maintained by APPX.

One option, Additional Attributes, is also available on this screen. This option accesses the Additional Attributes overlay for numeric Domain Fields shown in Figure 2-4-17. Upon completion, you are returned to the numeric Domain-type field specifications overlay.

Figure 2-4-17. Domain Field Additional Attributes Overlay for Numeric Domains

The Additional Attributes overlay for numeric Domain Fields contains the following:

·    Default Value establishes a modifiable starting value for all referenced fields whenever they are first displayed in add mode in an input image, unless modified by a user. If blank, there is no starting value displayed on the image.

·    Range Checks defines a series of allowable values that APPX uses for online data validation. The first component represents the relation. The options are EQ (equal to), NE (not equal to), GT (greater than), LT (less than), GE (greater than or equal to), and LE (less than or equal to). The second component represents the value that is assigned to the relation. If you enter two relations, APPX infers an AND relationship.

·    Occurrence determines the number of times a field is present in a record. If blank, APPX assumes a value of 1. This field may contain up to five numeric characters and is restricted to a maximum of 32,767. See the Occurrence section for a more comprehensive discussion of this field.

·    Use Domain Doc? Click the checkbox to toggle between “yes” if you want APPX to use the documentation from the domain as Help text and “no” if you plan to enter Help text unique to this field.

·    Print Totals? Click the checkbox to toggle between “yes” and “no” to indicate if this field should be automatically totaled on reports.