Group of radio buttons

Determines the type of data displayed in cells of auxiliary table:

Source – in every cell query field name and query record number are displayed separated by a comma. For the column of record numbers a special name <№> is indicated, for the row with field names symbol <Field names> is displayed instead of the record number.

Values – values of the corresponding query record fields are displayed in the cells.

Cells – addresses of cells of layout table being edited corresponding to the cells of the auxiliary table are indicated. An empty address value denotes that no cell of the edited table is associated with the present cell of the array of values, that is, this value will not be displayed in the layout. When the radio button Cells is checked, the user can change values of addresses thus changing location of displayed values in the table being edited.

Link with range

Used for quick specifying of the range of addresses of cells linked with selected array of values from query.

The user can enter the range of cell addresses of the edited table (addresses of the top left and bottom right cells separated by a colon). After pushing the button Apply elements of the array of values beginning from the top left corner of the auxiliary table are linked with the specified cell range.

If the specified range exceeds sizes of the array of values, the system will display a warning message and will offer to reduce the size of the range to the sizes of the array.

Pane of auxiliary table

An auxiliary table displayed on this page contains as many rows and columns as the number of records and fields included into the array of values on page “Source”. Every cell of the auxiliary table corresponds to the element of the array of values – to query record field or record number, or field name. Sizes of the array of values can be different from the number of rows and columns of the edited table. The system superposes the top left corner of the array of values with the top left corner of the block of cells of the table selected before calling the command of creating the array of values.