Delete Actions

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.