Step By Step Guide To Create Delete Actions In D365fo

 Create Delete Actions in D365FO

Delete Actions 

• Cascade 
• Restricted
• Cascade + Restricted

Click here to view detailed explanation of Cascade : View

Click here to view detailed explanation of Restricted : View

Step by Step Guide to Create Cascade + Restricted

Parent Table : LuOrganization

Child Table : LuStudentInf

Sub-Child Table : LuInf

Step 1 

Right Click on Table-->Select Add-->New Item-->Expand D365 Items-->Data Model-->Click on Table

Name : LuInf

Open Created Table : LuInf

Add Fields : Copy two Fields from LuOrganization Table 

• LuStudentId
• LuStudentName

Right Click on LuInf Table Fields & Paste

Step 2

Create Relation : Relation between LuInf Table & LuStudentInf Table

Fields

• LuStudentName
• LuStudentId

Step 3

Create Delete Action 

Open LuStudentInf Table

Right Click on Delete Actions -->Click on Create Delete Action 

Enter Properties 

• Set Action : CascadeRestricted
• Relation : LuStudentInf
• Table Reference : LuInf

Click on Save.

02Step 4

Right Click on Project & Click on Rebuild.

Right Click on Parent Table : LuOrganization Click on Open table browser

Right Click on Child Table : LuStudentInf Click on Open table browser

Right Click on Sub - Child Table : LuInf Click on Open table browser

Step 5

Now Click on LustudentInf Table Browser

I'm Trying to delete One Record : LuStudent Id : 530

Warning will Appear : LuStudentInf Record Cannot be deleted while dependent exists. Delete Luinf Record & Try Again. Image Show Below.

Step 6

04. Step 6

First delete Record from Sub-Child Table : LuInf

Open LuInf Table 

Select Record 

• Lustudent Id : 530

Click on Delete

Follow Below Images

Now Delete Record from  Child Table : LuStudentInf 

Open LuStudentInf Table 

Select Record 

• Lustudent Id : 530

Click on Delete

Follow Below Images

Step 7

Step 7

If I remove a record from the Parent Table . Records will be deleted automatically from Child Table & Sub - Child Table.

Follow Below Images

Successfully Created Cascade + Restricted in D365FO. Cascade + Restricted Video Available in Our YouTube Channel

More topics will be covered from time to time, so stay tuned. 

Subscribe Our You Tube Channel My Edition(Latestupdates07)