Does anyone know of anything out there or within Access that will allow you
to see how all the tables and queries are associated. In other words...I
would like to see which query/queries made a table...etc. Just something
that one could quickly map out how the database is flowing...that would be
very nice!
Thanks in advance.

look into "relationships" That will be a good starting point

I think that is what you are looking for
--
thomp


"Deeds" wrote:

> Does anyone know of anything out there or within Access that will allow you
> to see how all the tables and queries are associated. In other words...I
> would like to see which query/queries made a table...etc. Just something
> that one could quickly map out how the database is flowing...that would be
> very nice!
> Thanks in advance.

[Right-Click] on the Table, Query, or Form, and choose "Dependencies." The
relationships chart shows you how you have related Tables (and sometimes
queries) together, Dependencies show you how you have constructed Queries and
Forms. Probably need to look at both to get an overall picture of what is
connected to what. Can be useful for troubleshooting.

"Deeds" wrote:

> Does anyone know of anything out there or within Access that will allow you
> to see how all the tables and queries are associated. In other words...I
> would like to see which query/queries made a table...etc. Just something
> that one could quickly map out how the database is flowing...that would be
> very nice!
> Thanks in advance.

There is a pretty good documentation tool available from FMS called Total
Access Analyzer. Download a demo from www.fmsinc.com
While you're visiting the site, take a look at their white papers section.

"Deeds" <(E-Mail Removed)> wrote in message
news:A2CDFFDD-32D7-4AC2-8452-(E-Mail Removed)...
> Does anyone know of anything out there or within Access that will allow
> you
> to see how all the tables and queries are associated. In other words...I
> would like to see which query/queries made a table...etc. Just something
> that one could quickly map out how the database is flowing...that would be
> very nice!
> Thanks in advance.