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

  • 0
  • 1
  • Question
  • Updated 9 months ago
  • In Progress
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 Work PAckage tho these are old versions vs updated new versions. We would like to change the SOW Parent ID from the old SOW version to a new one as opposed to copying the records which is very easy but results in duplicate records when viewing from the Work Package. 

I could look at deleting the old Bill of Materials records from the older SOW but want to know if I can just transfer to a new parent?

Kind regards,

Josh
Photo of Joshua Tate

Joshua Tate

  • 1,016 Points 1k badge 2x thumb

Posted 9 months ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,306 Points 50k badge 2x thumb
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
(Edited)
Photo of Joshua Tate

Joshua Tate

  • 1,016 Points 1k badge 2x thumb
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:


Photo of Joshua Tate

Joshua Tate

  • 1,016 Points 1k badge 2x thumb
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.