New Bug Encountered:Orphaned Rows Created if Parent record is deleted

[Anthony_Nel]

Hi Team,

I am finding many orphaned rows in related tables - occurs if the parent is deleted on 1 device before a 2nd device that adds the child records is synced resulting in “orphans”

[Phil]

Hi Anthony,

You are correct and I am not aware of a good way to avoid this at present.

We have discussed blocking the child adds if the child records contains a Ref to the deleted parent and the Ref specifies “Is a part of”. Essentially “Is a part of” signifies that the child is only meaningful when a parent record exists. It is a form of “integrity constraint”.

No that it helps much, but you could use a scheduled rule (Report) to locate and delete the “orphans”.

[Steve]

Would a child’s Valid If expression of isnotblank([parent].[_rownumber]) prevent the server-side row addition, @Phil?