I want to start at the macro level (or query level) and document the queries, sub-queries, and tables that macro or primary query uses. I don't want to have a documenter that goes down one level only, because then I have to go to each query used in the macro and document that, then go to each query or used in THAT query and document the queries or tables used . . . etc. Gives me a headache.
I want:
Macro 1
. . . query 1
. . . . . . . table 1
. . . query 2
. . . . . . . query 3
. . . . . . . . . table 2
etc.
I want:
Macro 1
. . . query 1
. . . . . . . table 1
. . . query 2
. . . . . . . query 3
. . . . . . . . . table 2
etc.