This section explains how to delete records in a table. In Grid View you can delete several records at once, but only one at a time in Form View.
You can delete one record, a group of records, or all the records in table Grid View. All of these are done through the same "Delete" dialog.
If you want to delete just one record it is best to make this record the current one. Do this by clicking anywhere in the record. The current row pointer is displayed in the left row bar. If you want to delete several records at once, you can select (or mark) these records by clicking your mouse on the left row bar and dragging till the required records are all selected.
Next, click on the Delete button on the Record toolbar (or select Delete Record from the Record menu). The "Delete" dialog is displayed. Depending on whether you selected a current record, or marked one or more records, one of the following is checked in the dialog for deletion:
Current Record (deletes the record that has the pointer at its left)
All Marked Records (deletes all the marked records - note that the current record is not necessarily one of the marked records)
All Records (if you want to delete all records, then select this yourself - you can't delete the new record, of course)
Click on OK when you have chosen the records to be deleted. You will be warned that you cannot recover deleted records and asked to click Yes to continue with the deletion. The table will be redrawn with the deleted records removed.
The Delete command deletes the record and the row it occupies. However, if you use the Cut command instead, although the record and its row are both deleted, you can use the Paste command to paste the cut record in the new row at the end of the table.
To delete the current record in Form View, click the Delete button on the Record toolbar or select the Delete Record command from the Record menu. You will be asked if you are sure that you want to proceed with the deletion. The deleted record will no longer appear as one of the forms and is also deleted from the attached table.