Delete Actions:
1. Cascade.
2. Restricted.
3. Cascade + Restricted.
1. Cascade:
If you delete the record in parent table the relating records in the child table will automatically deletes.
2. Restricted:
If u deletes the records in parent table there is an error shown. There is a dependent in the child table.
3. Cascade + Restricted:
Setting the Delete Action property to Cascade + Restricted extends the functionality of the table's validate Delete and delete methods.
As a result, super (), in validate Delete, ascertains whether records exist on related tables. Whether deleting records from forms or X++, if validate Delete returns false, the primary record isn't deleted and the cascading delete isn't performed. You should first delete the records in the related table before deleting the primary record.
