How to add the parent record in the child record related list using scripted relationships?

[PratikK098]

My requirement: Need to add the parent Case record to the Child SIR-related list. if anyone knows how to add it using relationship please help me with it. Thanks in advanced!

[swathisarang98]

Hi @PratikK098 ,

You can try to create a relationship i tried something similar for change and release table please refer the below,

Here current belongs to Queries from Table , so in change table there should be reference record which is capturing release record number (reference field)

Parent is release table record so we have to query something like below

current.addQuery('u_release_record.number', parent.number);

So Related list will be created for 'Applies to table' which is release.

Please mark this comment as Correct Answer/Helpful if it helped you.

Regards,

Swathi Sarang

[PratikK098]

Hi @swathisarang98 , 

 There is no such reference field present in the case form for the SIR record. We are trying to create the SIR record from the Case record. So here Case is the parent record for SIR. The requirement is to show the SIR record in the Case form as there is no such reference field present for SIR record in Case form.