How to change the master table in master/detail relationship

  • 0
  • 1
  • Question
  • Updated 1 year ago
  • In Progress
This was asked 2 years ago but there were no responses.  Is it possible to change an existing master/detail relationship without having to recreate a new relationship?  

This is specifically related to a master/detail relationship between 2 applications.  The master application is being replaced with another similar application. Would like to point the details from the existing master app table to a new master app table.

Thanks
Photo of Ryan

Ryan

  • 170 Points 100 badge 2x thumb

Posted 1 year ago

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

QuickBaseCoach App Dev./Training, Champion

  • 53,842 Points 50k badge 2x thumb
There is no magic way to "point" the relationship at a new Parent table.  If you have a lot of lookup fields and do not want to go through the work to see where they were all used and then replace their use with the new lookup fields, one approach is to, one by one, change each old lookup field to a formula field. Then make the formula be just the value of the replacement lookup field.
Photo of Matthew Neil

Matthew Neil

  • 31,478 Points 20k badge 2x thumb
You can do this with the deep API that QB has, but is not for the faint of heart.  Most of the time, you just have to re-build it.
Photo of Ryan

Ryan

  • 170 Points 100 badge 2x thumb
Matthew, what is the deep API or is there documentation on that? I'm searching through the list of API calls here and don't see that. https://help.quickbase.com/api-guide/index.html
(Edited)
Photo of Matthew Neil

Matthew Neil

  • 31,478 Points 20k badge 2x thumb
Its not documented, its more of a trade secret :)  
I just call it the 'deep' API because its not documented.  Partially because they don't want people using it regularly.

QB support might be able to help you force change the relationship, but you'd have to get one of their senior techs, not just the person that is assigned to you.