User manual

Using databases 21
For more information about adding and duplicating records, see
Help.
Deleting records
When you delete a record, you permanently discard the data in all the
fields in that record.
Important You can’t retrieve deleted data, and you can’t undo the
action of deleting records.
Before you delete records, consider
making a backup copy of your file.
If you’re working in a relational database and the option to delete
related records is selected in the Edit Relationship dialog box,
FileMaker
Pro deletes related records when you delete a record.
Entering data
Note If a file is locked or write-protected, or if you don’t have
privileges to edit certain records or fields, you may not be able to
modify data.
Selecting a field
To delete Do this in Browse mode
One record Select the record to delete. Choose Records menu > Delete
Record, then click Delete.
Portal displaying
related records from
the Line Items table
Type in the last row of the portal to add a
related record to the Line Items table
A related record Select a portal row in the current table by clicking inside
the row but outside any fields in the row. Choose Records
menu > Delete Record, then click Delete.
Note To delete related records, Allow deletion of portal
records must be selected in the Portal Setup dialog box.
A group of records Make sure the found set contains only the records you
want to delete. (See “Finding records” on page 23.)
Choose Records menu > Delete Found Records, then click
Delete.
All records in a
database
Choose Records menu > Show All Records, then choose
Records menu > Delete All Records.
To Do this in Browse or Find mode
Select a field Click in the field.
Select the contents of
a field
Select the field, then choose Edit menu > Select All.
Move to the next field
in the field order
Press Tab, Return, or Enter.
Note To set the key(s) used to move to the next field, in
Layout mode, select the fields, then choose Format
menu > Field Behavior.
Move to the previous
field in the field order
Press Shift-Tab, Shift-Return, or Shift-Enter.
Move to items in a
value list
Press the arrow keys.
To delete Do this in Browse mode