To create a new array of values it is required to select the cell or the rectangular block of cells for which the link with the query should be set and then perform the menu command Data+Create Array of Values or push the button 
of data toolbar. A dialog box “Values from query” shown at figure 48-5 will be opened.
Figure 48-5. Dialog box “Values from query”, page “Source”
The page “Source” serves for determining used query, indicating its fields and records which should serve as a source of data for table cells.
The drop-down list Query contains names of all cataloged queries of the current GDB and also names of queries of all opened EDBs. The list contains also special value <None> which denotes that selected cells were not linked with any query or that they are linked with the query which has become inaccessible.
After one of cataloged queries is selected in the drop-down list, the left list in the pane Fields contains a list of all fields of this query. Using the button Add one can enter selected fields to the right list which contains query fields used as columns of array of values. It is possible to enter one and the same query field into the right list several times, it will cause duplication of one and the same values in several columns. The buttons Up, Down and Delete give a possibility to change the created list of fields.
The user indicates numbers of query records which will be used as rows of the array of values in the input field Record numbers. The example presented below the input field gives a sample of specifying a set of numbers using commas and hyphens.
If the user checks the box Include record numbers, one more column containing numbers of selected records is added to the list of fields selected as columns of array of values to the left of the table. If the box Include field names is checked, a row containing names of selected query fields is added to the set of selected records at the top.
As a result of working with the page “Source” the array of values being created should be determined, that is, the used query of GDB or EDB should be specified and at least one field and one record should be selected in it (the column of record numbers and the row of field names are also counted, if they are included). After that the system permits the user to pass to work with next page of the dialog box shown at figure 48-6.
Figure 48-6. Dialog box “Values from query”, page “Links with cells”
On page “Links with cells” the system shows how the elements of the array of values will be linked with table cells. 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 one element of the array of values – to query record field, or record number, or field name. Sizes of the array of values can differ 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.
Different data can be displayed in cells of auxiliary table depending on selected radio button:
Source – in every cell query field name and query record number are displayed separated by a comma. For the column of record numbers a conditional 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 value address 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.
The data corresponding to the radio buttons Source and Values can be only viewed, unlike the radio button Cells, when the user can change address values thus changing location of displayed values in the edited table if this radio button is checked.
Having selected a cell of the auxiliary table, the user can enter admissible address value of the edited table into it, that is, alphabetical number of the column and numeric number of the row, these numbers should not exceed the number of columns and rows of the edited table. In case of entering incorrect number the system will display a message: “Incorrect value” after which the user can either continue entering the value to enter corrected address value or cancel entering address into the cell.
It is also impossible to enter cell address of the edited table which is already associated with some element of array of values. In this case a message is displayed: “Includes already linked cells”.
It is allowed to enter several addresses of the edited table into one cell of the auxiliary table. Addresses should be separated by comma, without spaces. It will mean that the value of the present element of array of values should be displayed in several cells of the edited table. Another way to achieve similar result was described above, it is multiple inclusion of one and the same table field into array of values.
It should be noted that addresses being entered should not necessarily belong to the block of cells selected before creating an array of values. Selected block only determines initial correspondence between the array of values and table cells set by the system, but it does not limit the possibility to change this correspondence for the user.
To specify range of cell addresses quickly one can use the input field Link with range. 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.
Creation of the array of values is completed after pushing the button OK in the dialog box “Values from query”.
 |  |
