Query Hierarchy within a Database - Help!

[Guest]

Hello,

I have a database that houses about 15 reports. Each of these reports has
about 6-7 queries underneath it. So when I have to make a change...I have to
go backwards from the report source, to the query, to the query beneath that,
to the query beneath that, to the table beneath that...etc etc. This is very
cumbersome considering there are 15 reports like this. Is there any tool
that allows me to click a button or view a report or some function, and see a
complete hierarchy of each report and each query and table underneath it so I
can quickly go to the source query for each???

Thank you much and please let me know if you need some clarification.

Thanks!
MN

 

[Douglas J. Steele]

There's nothing built into Access to do this, but I believe Total Access
Analyzer, from FMS, does it
http://www.fmsinc.com/products/analyzer/index.html, as does 4Top Query Tree
editor http://www.4tops.com/query_tree.htm

 

[Guest]

Douglas,

Thanks a lot! Unfortuntaely I see that i have to buy a license for
both....know of any free programs that does this?

Thanks a lot!
MN

 

[Douglas J. Steele]

Afraid I'm unaware of any.