Create delete actions in D365FO Explained

 Create delete actions in D365FO Explained

The Delete Action part helps maintain info consistency once a record is deleted. outline delete actions to specify what ought to occur once information being deleted within the current table is said to information in another table.

• Have a delete action on each relation between 2 tables. ·
•  Use table delete actions rather than writing code to specify whether or not deletes area unit restricted or cascaded.

Cascade:

• A cascading deletion action can delete all records within the connected table · 
• whereas deleting a record, initial information|the info|the information} within the connected table is deleted then data within the Current table is deleted.

Restricted:

While deleting a record, if the record having any transactions then a warning message can seem. If the record isn't having any transactions in another table then solely deleted. · 

A restricted delete action can raise a slip message if the user tries to delete a record, wherever records exist within the connected table wherever the foreign key's resembling the first key of this table.

                                 Create delete action

Cascade delete action :

create two tables

1. SchOrganisation

2. SchEmployee

create a Delete action on parent table SchOrganisation with delete Action Property “CASCADE”

parent table ( SchOrganisation) . Set a delete action property to “CASCADE” for SchEmployee. Then  go and delete the record from a SchOrganisation. It will also delete all the related records in SchEmployee table automatically

Here am deleting the record SchDepartment(IT) Sch EmployeeId(503) from Parent Table i.e SchOrganisation

Data will be deleted in both tables

SchOrganisation Table:

SchEmployee Table :

Data after deletion in Above two tables :

SchOrganisation Table:

SchEmployee Table :

Restricted delete action

create  Delete action on parent table SchOrganisation for SchEmployee table with delete Action Property “RESTRICTED”

SchOrganisation Table:

SchEmployee Table :

parent table (SchOrganisation) . set a delete action property to “RESTRICTED” for SchEmployee table. Then  go and delete the record from a SchEmployee. It will first check the record in the child table and if exist that warning prompt saying that first we need to delete a record from child table.

Example : delete record SchEmployeeId(403) from SchOrganisation.

It Will throws Error

delete the same record “SchEmployeeId(403)” which I tried to delete before from SchOrganisation table,But this time am deleting that record from child table i.e SchEmployee table.

Done record deleted successfully.

But  record still exists in Parent Table i.e SchOrganisation.

Now  delete that record from parent table, record will be deleted without throwing any error

Click on yes button record will be deleted successfully

SchOrganisation table after delete action

The selected record was deleted.

Confused ? Then Watch Below Video