Self Join on External TO
Operating system version
Description of the issue
When self joining an external TO in the relationship graph the values in the second occurrence are not available unless the second file is open.
Steps to reproduce the problem
Create 2 files and reference Table A from File 1 in File 2. In file 2, create a self join of TO A. Relate Table B in File 2 to Table A.
Table B -> Table A -> Table A2
If File 1 is closed, data from the Table A2 is not accessible. When opening File 1, the data is now accessible from Table B. When closing File 1, the data is still accessible until closing and reopening File 2 without File 1 open.
Data from Table A2 should be accessible by File 2 regardless of whether File 1 is open or not.
Data from Table A2 is only accessible if File 1 is opened prior to its access by File 2.