Preventing Orphans

[Iainmck]

I'm attempting to use the following script to prevent users from deleting when this would result in orphaned records....

If [

[Mariano Peterson]

In FileMaker, modify the relationship definition so that the check box "When deleting a record in this file, also delete related records" is checked. This will automatically delete the child records whenever the parent is deleted.

If for whatever reason you do call a FileMaker script from the web, be sure that the FileMaker script doesn't perform any actions that would bring up a dialog box in the FileMaker application. If a dialog box (such as the result of a "show message" step) appears, FileMaker will not be able to respond to web requests until the dialog box is dismissed on the FileMaker Pro application.

[Iainmck]

Thamks Mariano

But I was hopeing to implemenmt a solution which prevents users from deleting child records unless the child recods have been explicitly deleted. Can anyone confirm that this is an impsoibility with FM?

Thanks

Iain

[Garry Claridge]

You can unselect "When deleting a record in this file, also delete related records".

A test can be performed to see if any child records exits. The user can then be prompted for the deletion of each of these records. The parent record can then be deleted.

All the best.

Garry

p.s. Look at using [FMP-InlineAction]