Reassign child records to a new parent (large number of records)

I�m not really understanding your relationships, and basically you have a set of records and need to update a field called something like Related Parent and you need to mass update that field to a new value.


It seems to me that you either already have a report link field or can make a report link field to the find that set of records. And then you can use an Action to do the mass update.

Pre-action can be triggered by some kind of button or checkbox field. The rockers you were sitting on would need to know the record ID for the new value.


So in the spirit of low no code I think that is a no code solution

I dont understand your response unfortunately - I have report links for Bill of Materials on the SOW and report links on Work Package for both Bill of Materials and SOW. 

We have 2 ways to create a Work Package, 1st is new work package, 2nd is in SOW use a coded URL to create a work package copying data from the SOW into API_NewRecord. Once a Work Package is created against an SOW any changes require a new SOW - you click a button to copy the SOW and mark the old as superseded. The New SOW presently has copied records from the OLD SOW which under the Work Package is showing double ups - I would like to just change the Parent ID of the BOM items in the old SOW to the ID of the new SOW - A code solution is what i assume but happy to have it explained how i can do it another way. I was thinking i might be stuck having to delete the old SOWs related BOM records. 

Please see my Pre-School A+ ERD below to illustrate my text:

My work around is to set a marker on the SOW like a checkbox saying retired and share this with the BOM, then set the report to only show records where that field  is false and set all calculations based on that field being false.