Create Delete Actions in D365FO
Delete Actions
- Cascade
- Restricted
- Cascade + Restricted
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)