Matrix

What is a matrix "field"?

A matrix, though you can choose it as a field "type" in the Field dialog, is not actually a field type itself, but a collection of two or more character fields whose exact position cannot be defined.

Do not confuse a matrix with indexed fields. Indexed fields are series of related fields with positions that can be defined exactly. You double-click or draw them one at a time and then fill in the Field dialog once for all of them.

A matrix of fields, on the other hand, is a group of fields whose position can vary within a defined area. (Click the links to examples below if you need a visual picture of what is meant by this.)

It is possible to define a character field containing more than one line of text without defining it as a matrix. Since that is a simpler solution, check first to see whether it would be a suitable solution before proceeding to define a matrix.

The matrix templates

After you select Matrix as the field type and name the matrix, click the Matrix tab. Then choose a template from the list box. The choices, and an example of each, are:

Limitations of matrix fields

Useful facts about matrix fields

Defining a matrix

Specifying the position of columns in a matrix

Specifying the position of the data within each column of a matrix

Adjusting FORMS’ handling of matrix fields

Matrix fields as demand fields