Hi All, Could anyone please help me with the issue.
I have a workbook which contains a total of 10 Joins and my driving table is say "Table 1" and all other tables are associated or joined with this "Table 1". But now the criteria of the project has changed and
now we are using say "Table 5" which belongs to the same 10 joins i am using but now Table 5 will be the driving table.
ISSUE: The problem I am encountering is when I am trying to make "Table 5" my driving table instead of "Table 1" all joins are being removed and In that case I will have to rebuild all my tables from scratch.
Did you try to drag table5 over table1?
Doing it you replace table1.