Change Master to Different Master For Table Relationship

  • 0
  • 1
  • Question
  • Updated 4 years ago
  • Answered

I have an existing table relationship with lots of fields pulled into the child table.  This is setup as a cross-application table relationship.   Is there a way to change the Master table being used without having to recreate all the fields, and recreate all the reports that uses these fields?   I thought just going into the reference proxy area would work, but looks like all i can do is change the foreign key being used.

The reason for this is that we have a duplicated new application to replace the previous, and want to point the cross application relationship to the newer app.


Thanks!

Photo of Ryan

Ryan

  • 200 Points 100 badge 2x thumb

Posted 4 years ago

  • 0
  • 1
Photo of Ryan

Ryan

  • 200 Points 100 badge 2x thumb
Ah. see it now..  Unless there is another way, i had to create a new relationship, and then go into the old relation table of fields and reassociate each field to the new master table..
Photo of Ryan

Ryan

  • 200 Points 100 badge 2x thumb
other than the reference field because a new field id... so any API code referencing that would have to change.