Table Editor Shortcut Menu

Most data grids in WRDB provide a shortcut menu containing frequently used commands. Display this menu by right-clicking on the grid:

Grids that are in read-only mode display this menu:

Copy: copy selected records (all fields) to clipboard (tab delimited)

Select All: select all records in table

Find: prompts you to find first record containing value for field you were on when you right-clicked

Find Next: move to next record that matches

Export to Excel: export all records in table to a new Excel spreadsheet and opens the application to display the file contents

Print: displays a print preview form containing all data in the grid; formatting of wide reports is controlled by the Report Scaling setting configured under Project Preferences

Create PDF...: prompts you for the name of the Adobe PDF file to create or append to, then displays the file that was created in your default PDF reader

In grids that allow editing this menu is displayed:

Cut: place all selected cells on the clipboard and delete the entries

Paste: replace all selected cell with the contents of the clipboard

Delete: delete contents of all selected cells

Search & Replace: prompts you to enter the search and replace substrings

Sort by Column: sorts grid by column you were on when you right-clicked

Fill: paste contents of top-most selected cell to all other selected cells

Series: fill selected numeric or date cells with a auto-incrementing series

Multiply: all numeric values in the selected cells are multiplied by a factor you specify

Add: all numeric values in the selected cells are added to by a value you specify

Delete Rows: entire rows associated with the cells currently selected will be deleted