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.