Contents of the Rollup Definition Dialog Box
Use the fields and options to configure the Rollup Definition dialog box.
Contents
| Field | Description |
|---|---|
| Name |
If you are creating a new rollup definition, you can enter the name for the definition in this field. If you are creating a copy of an existing rollup definition, the copy is given the default name of Copy_<existing name>. You can change the name if you wish. If you are editing an existing rollup definition, its name displays in the field, but you cannot change it. |
| Applies to Table |
The table name that displays in this field is the table that was chosen on the Rollups dialog box. The rollup definition will use the fields contained within the selected table. |
| Available Fields |
This list contains all the data and numeric fields for the selected table that are available for roll up. When you select a field and click the right arrow button, the field is moved to the Assigned Fields list. You can select multiple fields to move at one time by using CTRL+click or SHIFT+click for the fields that you want and then clicking the right arrow button. |
| Assigned Fields |
This list contains the fields that have been assigned for rollup. The rollup definition can contain as many fields as you wish to roll up. You can remove a field from the assigned list and place it back in the Available Fields list by selecting it and clicking the left arrow button. You can select multiple fields to remove at one time by using CTRL+click or SHIFT+click for the fields that you want to remove and then clicking the left arrow button. |
| Access Control |
This item is initially accessible only to the user who created it. If you wish to share this item with other users, click the Access Control button to display the Access Control dialog box. |