After you modify data in a table, you can select to view only the edited data rows. Filters are available for updated, deleted, or inserted data. This feature is useful if you've made multiple changes in a large table and want to review your changes before updating them in the database. It can also be used to group changes for export to a file, either as a record or for later review.
- With an edited table open in the Table Data grid, click the Filter by Edits icon in the toolbar. The Show Edits dialog opens.
-
Select which type of edit to display by checking one or more of these options:
- Select the Inserts check box to display any rows with newly inserted data in the table.
- Select the Updates check box to display rows in which data has been added, edited, revised, or deleted.
- Select the Deletes check box to display rows removed from the table.
- Click OK. The Table Data Editor refreshes to show only table rows that match the filter options you selected.