Forum Discussion

RyanAnderson2's avatar
RyanAnderson2
Qrew Cadet
8 years ago

How to change the master table in master/detail relationship

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
App builders
Ask about Quickbase functionality
Relationships
  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    8 years ago
    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.
  • MCFNeil's avatar
    MCFNeil
    Qrew Captain
    8 years ago
    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.
    • MCFNeil's avatar
      MCFNeil
      Qrew Captain
      8 years ago
      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.