Field Definition window: Fields


Field Name

Displays the name of the current field.

Physical Name

The physical name is a shortened version (up to 24 characters) of the field name, and is used as the column name if the field is used in a SQL table.

Lookup Form

Allows you to attach a lookup form to the field. When a lookup form is attached to the field and the focus is on the field, the user can open the attached form by choosing the Lookup menu item.

Click the lookup button to open the Resource Lookup window, where you can select a form to function as the lookup form.

Array Size

An array field contains multiple occurrences of the same type of information. The individual pieces of information stored by the array field are referred to as elements. When you create a field, you can enter an array size for the field. The array size of a field indicates the number of elements that will be included in the array field. If the field won't be an array, set the array size to 0.

For example, you could create an array field called Phone to store two phone numbers by specifying an array size of 2. Note that Phone is a single field, but that it has two elements, each containing a phone number.

Data type

Displays the data types that have been defined in this dictionary. Each field you create must be associated with one of the data types previously defined for the application. The data type, which specifies most of the characteristics of the field, can be used by other fields, as well.

To view or change the settings for a data type, select a data type and click Open. The Data Type Definition window for the data type you selected will appear, allowing you to view or change the options for the data type. Click New to create a new data type.

Documentation Feedback