deleting associated records as deleting the parent record

(0) Share

Report

Posted on by agorkemt

Hello all,

I have been building a multi screen app and all the screens are connected with each other in the SQL Server Database. Think it as a tree structure, so A > B > C > D > E > F, in this case A is the parent of all and B is child of A and C is child of B etc...

What i do want to achieve is when I delete a Parent Record for example C, I would like to automatically delete D,E,F also. so to achieve this i used this formula but it works for the parent but not for the child;

// Remove the selected article
Remove(Articles, ExistingArticle_Gallery.Selected);
// Remove associated records in ArticlesLookup
RemoveIf(Article_Volumes, Article_Parent_LookUp_ID = ExistingArticle_Gallery.Selected.Article_ID);
 
does any of you know a solution to this?
 
Thanks in advance

Categories:

General Questions

Connecting to Data

All responses (1)

Answers (1)

Verified answer

Pstork1 64,090 on at

Like (1)

Report

deleting associated records as deleting the parent record

To do this you need to make sure you remove the child records BEFORE removing the parent records. So the code you are using should work, but it needs to be in the reverse order.