Reassign child records to a new parent (large number of records)
Hi QuickBase Community, I have a Table called SOW, which is a Child to Work Packages, Both Work Packages, and SOW have a parent relationship with Bill of Materials. We can have multiple SOWs to a W...
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:
