Reference > Script steps reference > Records script steps > Delete Record/Request
 
Delete Record/Request
Purpose 
Deletes the current record or find request.
See also 
Format 
Delete Record/Request [With dialog: On/Off]
Options 
With dialog specifies whether to display a dialog box when the script step is performed, asking users to confirm deletion of the record or request.
Compatibility 
 
Where the script step runs 
Supported 
FileMaker Pro 
Yes 
FileMaker Server 
Partial 
FileMaker Go 
Yes 
Custom Web Publishing 
Partial 
FileMaker WebDirect 
Yes 
Runtime solution 
Yes 
Originated in 
FileMaker Pro 6.0 or earlier
Description 
Important  You cannot undo a Delete Record/Request script step.
In Browse mode, this script step deletes the current record. In Find mode, it deletes the current find request.
 
To delete
Do this
A master record
Make sure that the record you want to delete is active (use navigation script steps), and then use Delete Record/Request. If the current layout contains a portal, click anywhere on the record outside of the portal to make sure that no related record is selected, then use Delete Record/Request.
A related record
Perform Delete Record/Request in an active portal row, or use the Delete Portal Row script step.
Note  Performing Delete Record/Request in an active portal row will delete the related record even if the relationship the portal is based on doesn't allow for the deletion of records.
A find request
Make sure that the find request you want to delete is active (use navigation script steps), and then use Delete Record/Request.
Example 1 
Goes to a related record and asks if the user wants to delete it.
Go to Related Record [From table: "Products"; Using layout: "Product Details"]
Delete Record/Request [With dialog: On]
Example 2 
Displays a custom dialog box to ask if the user wants to delete the current product.
Show Custom Dialog ["Do you want to delete " & Products::Name & "?"]
If [Get ( LastMessageChoice ) = 1]
Delete Record/Request [With dialog: Off]
End If
Related topics 
Script steps reference (alphabetical list)
Script steps reference (category list)
Was this topic helpful? Send feedback.