You can define a table control to display the records as you like. In other words you can define data fields for displaying or editing data like in a database form.
The following fields are possible in a table control: text, date, time and currency field, numeric field, pattern field, check box and combo box. In the case of combined date/time fields, two columns are created automatically.
The number of selected lines, if any are selected, is in parentheses (round brackets) after the total number of records.
To insert columns into the table control, click in the column heads and bring up the context menu. The following commands are available:
Calls a sub-menu to select a data field to adopt it in the table control.
Configure the table control using drag-and-drop: Open the data source browser and drag the desired fields out of the data source browser and on to the column heads of the table control. A pre-configured column is created.
Opens a sub-menu to select a data field to replace the data field selected in the table control.
Deletes the currently selected column.
Opens the properties dialogue box of the selected column.
Hides the selected column. Its properties are not changed.
Calls a sub-menu where you can select the columns to show again. To show only one column, click the column name. You see only the first 16 hidden columns. If there are more hidden columns, choose the More command to call the Show Columns dialogue box.
Calls the Show Columns dialogue box.
In the Show Columns dialogue box you can select the columns to be shown. Hold down the Shift or CommandCtrl key to select multiple entries.
Click All if you want to show all columns.
If you use the keyboard only to travel through controls in your document, you will find one difference to the other types of controls: the Tab key does not move the cursor to the next control, but moves to the next column inside the table control. Press CommandCtrl+Tab to move to the next control, or press Shift+CommandCtrl+Tab to move to the previous control.
The form document must be in Design mode.
Press CommandCtrl+F6 to select the document.
Press Shift+F4 to select the first control. If the Table Control is not the first control, press Tab until it is selected.
Press Enter to enter the edit mode. The handles are shown farther out from the control border.
In the edit mode, you can open the edit mode context menu by pressing Shift+F10.
If you want to edit columns, press Shift+Space to enter column edit mode. Now you can rearrange the order of columns with CommandCtrl+Arrow keys. The Delete key deletes the current column.
Press the Esc key to exit the edit mode.