I have a setup where I have different database connections in different Application folders. Each of these databases have a lot of the same table names. I am attempting to do a report where I need data from both of those databases from the same table name. How can a do a normal TABLE FILE command and specify which master file I want?

You will need to set the APP PATH to choose

You could also have single versons of the MAS and ACX file and then dynamically set your connection within your code.

This has been discussed on the forum and you should be able to use search to locate posts with "connection".

T

You can also change the Master File names in seconds APP folder, so that each master file names are unique(though they have same table name in access file).
Then use Universal Concatenation MORE phrase,to retrieve data in single TABLE FILE request.

Thanks,
Ram

We usually have the schema name as a prefix to the master/access file names. You could add the database name as a prefix...

You can also specify the app folder name:

TABLE FILE BASEAPP/CAR

TABLE FILE TEST/CAR