Discussions

Expand all | Collapse all

How to change the master table in master/detail relationship

  • 1.  How to change the master table in master/detail relationship

     
    Posted 07-07-2017 12:55
    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


  • 2.  RE: How to change the master table in master/detail relationship

    Posted 07-07-2017 13:19
    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.


  • 3.  RE: How to change the master table in master/detail relationship

    Posted 07-12-2017 04:53
    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.


  • 4.  RE: How to change the master table in master/detail relationship

     
    Posted 07-12-2017 12:01
    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


  • 5.  RE: How to change the master table in master/detail relationship

    Posted 07-12-2017 14:49
    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.