+ Start a Discussion
Natraj Subramani 15Natraj Subramani 15 

Child Case Count

Hi All,

We have a parent child relationship on the Case object. Basically a self look up relationship. 

We would like to know the number of child cases a parent case has and store in a field called "No of child Cases"

Any suggestions to get this requirement accomplished ?

Thanks
Natraj
Bavadharani GanesanBavadharani Ganesan
Hi Natraj Subramani,

You can achieve this by simply creating Roll up summary field
Natraj Subramani 15Natraj Subramani 15
Hi Bavadharani,

Roll up summary works only for Master Detail and not on look up relationship.

Thanks
Natraj
Natraj Subramani 15Natraj Subramani 15
Unfortunately this is one of the limitations, wondering if there is any workaround.
Bavadharani GanesanBavadharani Ganesan
Hi Natraj,

Then you can prefer triggers for the above requirement.
Natraj Subramani 15Natraj Subramani 15
Hi Bavadharani,

Thank you, will do the same. Wanted to check if there any point and click options before opting for triggers.

Thanks
Natraj
Bavadharani GanesanBavadharani Ganesan
Hi Natraj,

Have you tried cross-object formula field?
Natraj Subramani 15Natraj Subramani 15
No Bavadharani, its a self look up on the case object. We have a parent case field on the case object, would like to know how many child records does each parent have via look up ?