Working with Data in Grids

Most forms (screens) in FDM display data in one or more grids. To manipulate grid data, perform one or more actions:

To add a record, click Add.
To delete, select a record and click Delete.
To delete all records in a grid, click Delete All.

Note:

If a form contains multiple grids, you cannot delete the contents of a grid.

To edit a record, click within its cell, and start typing.
To cancel all changes made to a row, click to the left of the row and select Cancel Changes.
To save a record, click Update Grid.
All changes on the current grid are sent to the database.
To send updated rows (adds, deletes, and changes) to the database, click Update Grid.
To output the contents of a grid to an Excel spreadsheet, click Excel.
The Excel spreadsheet is saved to the Excel subdirectory inside the Outbox directory that is specified in the Connections Dialog form.

Note:

Screens exported to Excel are configured for re-import (where available) into FDM. The named range is automatically defined, and the Import table name and column names are set.