I have received 1000 incidents in SD, and would like to keep first incident( ex: ref_num='10') as parent and rest to map/update as children of this incident.
I have tried update query where updating persid of parent number to child incident( update call_req set persid='***' where ref_num='child ref_num').
Unfortunately am able to see child incident number in parent incident, but not as vice versa.( i.e parent incident number in children incident).
Is there any other option available to achieve this instead of doing it manually, as count is too high.. kindly help.