Deletes the current record or find request.
Adding, duplicating, and deleting records
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.
Product | Supported |
FileMaker Pro Advanced | Yes |
FileMaker Go | Yes |
FileMaker WebDirect | Yes |
FileMaker Server | Partial |
FileMaker Cloud products | Partial |
FileMaker Data API | Partial |
Custom Web Publishing | Partial |
Runtime solution | Yes |
FileMaker Pro 6.0 or earlier
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. |
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]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