Delete Record/Request

Deletes the current record or find request.

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 

Product Supported
FileMaker Pro Yes
FileMaker Go Yes
FileMaker WebDirect Yes
FileMaker Server Partial
FileMaker Cloud products Partial
FileMaker Data API Partial
Custom Web Publishing Partial

Originated in version 

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.

Copy
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.

Copy
Show Custom Dialog ["Do you want to delete " & Products::Name & "?"]
If [Get ( LastMessageChoice ) = 1]
Delete Record/Request [With dialog: Off]
End If