Forum Discussion

PrashantMaheshw's avatar
PrashantMaheshw
Qrew Captain
5 months ago

Deleting Orphaned Children (records)

Hellos, I have a scenario where I have a table where orphaned children exists , they can be recognised visually from hyperlink (See Screenshot). The question is how to filter for them so they can b...
  • MarkShnier__You's avatar
    5 months ago

    The way I do this is I go to the parent record and make a checkbox formula field with the formula of TRUE and I name the field [Parent exists?]

    I then do a look up of that field down to the child records. If that look up field is false that means there is in fact, no parent.