Generate report showing tables and fields used in queries

[cowboy1015]

Hi,

My source data comes from Oracle. I got a query that creates a new table and populate it with the data from Oracle.

I just want to generate a report to map the fields and tables from the queries to the Oracle source fields and tables.

for example:
query1
------
access.field1 -> oracle.field1
access.field2 -> oracle.field2

This queries that I found here comes close. But im not a access developer so im having a hard time:

SELECT DISTINCTROW MSysObjects.Name, MSysQueries.Name1
FROM MSysObjects LEFT JOIN MSysQueries ON MSysObjects.Id = MSysQueries.ObjectId
GROUP BY MSysObjects.Name, MSysQueries.Name1, MSysObjects.Type
HAVING ((Left$([Name],1)<>"~") AND (Not (MSysQueries.Name1) Is Null) AND ((MSysObjects.Type)=5))
ORDER BY MSysObjects.Name, MSysQueries.Name1;

Any help is well appreciated.
Thanks.

 

[MichaelRed]

Close? Cigar? Where are the ashes? (e.g. What is amiss with the results?)





MichaelRed