Relations between queries

[Nanuaraq]

Hi there



Recently I've been having to do some pretty specifik queries and I've found that it helps to make the query in more than one step. Sometimes, That's the only way I can do it, for example if I wish to see totals and then query further on those totals. Also, I might need a basic query expression and then do multiple queries based on that, so that I might for example change a parameter in the basic query withouth doing the change in all my multiple queries.

I am in search of a tool that lets me see which query is the basis for which other query.

Iv'e been introduced to a tool callede KNIME that seems to do what I would like access to do. It graphically presents to me what steps I've done in querying queries. But that's a new tool, and I like to keep things simple so it would be nice to do in Access that I already knows.

What would you recommend?

[aytee111]

I think most people would use naming conventions, such as
nameofquery_a
nameofquery_b
....
nameofquery (this being the final one, such as GetAllTotals_qry, all the queries with the same name lead up to this one)

[Bulzie]

As aytee111 said, I name mine same with numbers or description:

qryCustMain
qryCustDetail

qryPatTotal1
qryPatTotal2 (qryPatTotal1 as source)
qryPatTotal3 (qryPatTotal2 as source)

[Nanuaraq]

Oh well, I already do that. Should have mentioned it of course.

What I'm looking for is a graphical tool that shows me visually, much like relations between tables.

Thank you anyway

[Bulzie]

You might check out Object Dependencies in the Tools tab. Looks like if you highlight a table on left and have "Objects that Depend on Me" selected, it will give you a tree view of queries that use it in that section. Did not seem to work as well when I highlighted the first query in a next of sub queries. But maybe play with it, might give you some info. Other thing would be the Database Documenter, can give you some reports on objects if you limit the options but not sure it will give you the graphical view you want.

Look like you can create relationships for queries, I have never done that so not sure how that affect your actual queries but does give you the graphical view. Maybe link the tables and queries into a separate database to only use to view query relationships or something. Of course there may be other 3rd party tools like you found that can do something. Have you looked at Visio maybe?

[Nanuaraq]

You might check out Object Dependencies in the Tools tab. Looks like if you highlight a table on left and have "Objects that Depend on Me" selected, it will give you a tree view of queries that use it in that section. Did not seem to work as well when I highlighted the first query in a next of sub queries. But maybe play with it, might give you some info. Other thing would be the Database Documenter, can give you some reports on objects if you limit the options but not sure it will give you the graphical view you want.

Look like you can create relationships for queries, I have never done that so not sure how that affect your actual queries but does give you the graphical view. Maybe link the tables and queries into a separate database to only use to view query relationships or something. Of course there may be other 3rd party tools like you found that can do something. Have you looked at Visio maybe?

Thank you for the hint on Object Dependencies. Even without the visual representation, this is a nice tool for keeping check on query dependencies.

To do relations between queries or using Visio is really just a neat way of drawing it up, but does not - if I guess correctly - actually make Access keep check of it for me.

I'll keep looking, but the Dependencies at least makes things easier