I have one object, for example Area
. It has two lookup relationships to itself, Parent__c
, Child__c
. In result I can create record with Parent
and Child
parameters. I am trying build hierarchy.
And when I delete a record, I want delete all of its children, and children of its children, ad infinitum. Long story short, imitation of Master Detail
relationship. Why don't I use Master Detail
? Because a Master Detail
relationship cannot refer an object to itself.
How can I resolve?