One of the most important properties of the table as a layout element is the possibility to display data contained in queries of the current GDB. It is possible to set a source of data – a record field of some query for any table cell. There is also a possibility to specify a source of data for a rectangular array of cells.
The notion of an array of values is used to describe links between a query and table cells. Such an array is a set of fields and records of a cataloged query of the current GDB which should be used as a source of data. The user should also indicate in which table cells the corresponding values from the array should be displayed.
If the user indicated the used query when creating a table, one array of values is created together with the table. Later when editing the table the user can specify new arrays of values and change the existing ones. It is possible to use several arrays of values for one table; using different queries or one and the same query is also allowed.
Instead of using a source of data a table cell can contain data entered into this cell from the keyboard or by copying. Cells can also remain empty.
Table cells linked with the array of values display actual status of the query. If the query was changed, or the data from GDB tables displayed in the query was changed, next time the layout is opened (or the opened layout editor window is activated), changed values will be displayed in table cells.
If the query used when creating an array of values becomes inaccessible later on (it can happen if the query was removed or if the EDB to which the query is referred is closed at the moment), when displaying the table in the layout the corresponding cells contain the string “???”, and when editing the table the cells display the message “{Query is absent}”.
To unlink the cell from source of data it is enough to enter a new value into the cell from the keyboard or clean the cell.
The user can see which of the table cells are linked with arrays of values performing the menu command View+Highlight Arrays of Values (the button
of the standard toolbar). All the cells linked with different arrays of values will be highlighted by fillings of different colors, and the cells which are linked with neither of arrays will be shown against white background.