Do you know if it is possible to connect to multiple databases, and load the same table from each database. The screenshot below demonstrates my issue:
I am trying to load the table entitled GL_ASSET from two databases. I have renamed one table Mainttest_asset and one housing_asset, yet despite connecting to both, it loads both tables as Mainttest_asset and when creating a chart, list box etc, I only see one instance of this table, with one set of data loaded in it. Despite this, it has loaded another table from the second database connection.
Is it therefore possible to load the same table from different databases if they have the same name?
Any help would be greatly appreciated