Deleting children/detail records
When deleting a record in the parent form of a master-detail (Parent form to sub-form) relationship, I am finding that the children records are NOT automatically deleted, they are left as zombies!
Does that mean I have to create a foreign-key field in the sub-form that relates to the primary key in the parent form? if so, then I have to create a deluge script on "Delete" at the form level to fetch all the related records in the sub-form and delete them. Am i correct on this, or is there something else I am missing, which automatically happens, say Zoho Creator automatically establishes an ID relationship??
Please advise!
Thanks