How to delete children records?

[pbdavis]

I have a form with relationships. I need the ability to selectively delete the children. I get the child in a record I want to delete. But the deleteRecord(rec) deletes all the children and the parent record in another table.

Code: Select all

function onAction(event) {
   // Delete selected image record.
   var rec = forms.frm_MOD_fsr_image_pict_Edit.foundset.getRecord(1);
   application.output("Rec id = " + rec.fsr_image_id);
   forms.frm_MOD_fsr_image_pict_Edit.foundset.deleteRecord(rec);
}

Can someone tell me why this is deleting Parent and children? And how to delete just the selected child?

[mboegem]

Hi Paul,

Just a wild guess, since I don't know what your solution looks like.
I think you have to relations in your solution:
1) child_to_parent
2) parent_to_children

If this is the case most likely both relations have the 'delete related record' checkbox ticked.
I can imagine this should be the case for the 2nd relation, but definitely not for the first one.

Hope this helps.

[pbdavis]

Awesome Marc! That was it. There was a child_to_parent relation with 'Delete related record' checked.
Thanks some much. This one had me stumped.
~Paul