Skip to main content
Question

How to change the master table in master/detail relationship

  • July 7, 2017
  • 0 replies
  • 30 views
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
    This topic has been closed for replies.

    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
    • Registered
    • July 12, 2017
    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.
    Terms & ConditionsAccessibility statement