Adds a new record to the end of table.
Inserts a new record before the current record.
Duplicate record command
Hot key: Ctrl-F5
Adds a information from current record to the end of file
Hot key: F7
Displays find dialog (Query by example) for searching from first record in table.
You can set search string for each field separately. You can also use the F7 key for start search.
The current query saved for future searches. Find Next command for continues a search, use key F3
You can use metasymbols in search expressions:
?-any character in current position, *-any characters after '*'
*aa- search "aa" in any position
Example Matches Doesn't Match
ab* abc cab
a?b* aabc aadc
*ab cab,abc cba
>, >=, <, <=
(For Number, Float, Integer, Currency, Double fields)
You can set range for date/Timestamp fields and all numeric types.
Hot key: Ctrl-R
Displays replace dialog for replace field in records, you can set wilcard for field.
Hot key: Ctrl-L
Fill records in selected field to constant or record number.
Delete/Recall record command
Hot key: Del
Mark or Unmark record as deleted.
Hot key: Ctrl-T
Delete records from file after the current record
Hot key: Shift-P
Erase all records marked as deleted.
Remove all records
Hot key: Ctrl-Z
Goto Record command
Displays dialog for input record number (1-N, where N- records count in file)
Hot key: F6