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 | 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 |
|
The current 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