Reference > Script steps reference > Records script steps > Delete Record/Request
 

Delete Record/Request

Deletes the current record or find request.

See also 

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 Advanced 

Yes 

FileMaker Go 

Yes 

FileMaker WebDirect 

Yes 

FileMaker Server 

Partial 

FileMaker Cloud for AWS 

Partial 

FileMaker Data API 

Partial 

Custom Web Publishing 

Partial 

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)