Output Field Type Descriptions
Database
A database field is a field you select from the primary or detail file, or from a file with a one-to-one relation with these files.
Compute
A compute field computes its value using selected fields, values, and operators. For instructions, see Defining a Compute Field.
Array Value
An array value field can access a specific value in an array or sum the values in an array (a field with multiple occurrences containing a list of data). For instructions, see Defining an Array Value Field.
Record Count
A record count field sums the number of records in the primary file or in a file with a one-to-many relation from the primary file.
For example, the Location file has a one-to-many relation from the Company file (that is, a company can have one or more locations associated with it). To display the number of locations in a company, you can define a record count field using the Location file.
One-to-Many (OTM) Field
A one-to-many field displays the values of a field from the first record of a one-to-many relation. You can select a one-to-many field from a file with a one-to-many relation from the primary file.
For example, Company is the primary file on a form. The Location file has a one-to-many relation from the Company file (that is, a company can have one or more locations attached to it). To display the first location in a company, paint Location as a one-to-many field. The following graphic is a sample of Location file records. When the form displays Company 1, a 1 (the first location in company 1) appears in the one-to-many field, Location. When the form displays Company 2, a 10 appears in the Location field.
| Company | Location |
|---|---|
| 1 | 1 |
| 1 | 2 |
| 1 | 3 |
| 1 | 4 |
| 2 | 10 |
| 2 | 20 |
One-to-Many (OTM) Sum
A one-to-many sum counts the number of records in a file with a one-to-many relation from the primary file.
For example, each invoice record in the Invoice file has several items that are stored in the Invoice Detail file. Each item on the invoice has a cost that is stored in the Line Cost field. To display the total cost of the invoice, paint the Line Cost field as a one-to-many sum field.
The following graphic is a sample of Invoice Detail records. When the form displays Invoice 1, 26.00 (the sum of the Line Cost for Invoice 1) appears in the one-to-many sum field, Line Cost. When the form displays Invoice 2, 90.00 appears in the Line Cost field.
| Invoice | Item | Line cost |
|---|---|---|
| 1 | A | 1.00 |
| 1 | B | 15.00 |
| 1 | C | 10.00 |
| 2 | X | 90.00 |
Current Date
A current date field displays the current date on the form. You can paint only one current date field on a form.
Current Time
A current time field displays the current time on the form. You can paint only one current time field on a form.
Order Name
An order name field displays the translation (description) of the order field value you type on the form. For more information, see the Order field description in Painting Fields on a Form - Input Field Types.