Adding, duplicating, and deleting records

To

Do this in Browse mode

Add a record in the current table

Click New Record in the status toolbar.

Add a record in a related table

•If the related field is in a portal, type data into the field in the last row of the portal, then commit the record (for example, by clicking anywhere outside the record or selecting another record).

•If the related field isn't in a portal, type data into the field, then commit the record (for example, by clicking anywhere outside the record or selecting another record).

Duplicate a record in the current table

Select the record. Choose Records menu > Duplicate Record.

If the record displays related data in a portal, make sure no records are selected in a portal before duplicating the record.

Duplicate a related record in a portal

Select the related record in the portal (making sure the whole row is highlighted), then choose Records menu > Duplicate Record.

Delete one record

Select the record. (If your layout displays related records in a portal, select anything other than a portal row.) In the status toolbar, click Delete Record.

Delete a related record

Select a portal row by clicking inside the row but outside any fields in the row. Click Delete Record, then click Delete.

Delete a group of records

Make sure the found set contains only the records you want to delete. Choose Records menu > Delete Found Records.

Delete all records in a table

Click Show All, then choose Records menu > Delete All Records.