Report that shows Query dependencies

[ChuckColeman1812]

I have a database that reuses many queries in several different macro's. Does anyone know of a way to generate a report, (or purchase an add-in), that will show for each query any other queries that use it. It would be ideal to show all of the "cascading" queries that one query is built on. It just gets confusing when I need to tweak a query to then have to figure out there are other queries that use the one that's being tweaked and the tweak will change the results of the other queries. Any ideas?

Thanks,

Chuck

[bcofie]

with query selected, click on database tools menu, and choose object dependencies in the Hide/Show ribbon.

Hope this helps

[ChuckColeman1812]

Thanks bcofie. I had to turn Track Changes on. Do you or anyone else know of any issues created by turning Tack Changes on, (other than an increase in file size)?

Chuck

[ssanfu]

Thanks bcofie. I had to turn Track Changes on. Do you or anyone else know of any issues created by turning Tack Changes on, (other than an increase in file size)?

Chuck

Lots of problems.....

See Allen Browne's site:
Failures caused by Name AutoCorrect

http://allenbrowne.com/bug-03.html