Selecting Field Values

In order to select a value from a field, simply click the value. Once selected, the cell turns green to indicate its new state, selected. The selection may affect the states of a large number of values in the other sheet objects, on the current sheet as well as on other sheets.

White cells represent optional field values, and gray cells represent field values excluded by selections. When a selection is made, natural joins are dynamically evaluates between all the associated tables.

Selections can be made in most kinds of sheet objects.

To deselect a previously made selection, click it again. Alternatively, choose Clear from the Object menu, or choose one of the Clear commands in the Selections menu. When an excluded value is clicked, selections in conflict with this value are canceled, and the value clicked becomes selected.

Selections can also be made by searching the wanted values.