Relationships automatically set

[Ignacio]

Hello, I'm trying to see a map of the relationships between the different
queries and tables of a Database.
I've already created more than 100 queries in the database and I want to get
a graphycal view of how are they related to each other. I tried the "Object
Dependencies" tool but, althought it is very clear to understand what
queries/tables are related to the query, it does not show de dependencies
graphically.
Is there a function/command/etc that show me graphically how the different
objects in the database are related?. Considering that when I created the
queries I sort of told Access how the different fields related between each
other, can Access create the relationships automatically?.
Hope ypu can help me

Regards
Ignacio

 

[mnature]

[Right-Click] on a table or query or form, and select [Object Dependencies]
from the list. You can then look at what the object is dependent on, or what
depends on that object.

 

[Ignacio]

mnature,
Thanks for answering so quickly but what I'm looking for is a graphical map
of depencies between the queries and tables of the database, the same thing
that is shown in "Object Dependencies" but in graphical manner (as
"Relationships").
Doesn't Access create "Relationships" automatically.

Once again thanks for your help

Regards

Ignacio

[Right-Click] on a table or query or form, and select [Object Dependencies]
from the list. You can then look at what the object is dependent on, or what
depends on that object.

Hello, I'm trying to see a map of the relationships between the different
queries and tables of a Database.
I've already created more than 100 queries in the database and I want to get
a graphycal view of how are they related to each other. I tried the "Object
Dependencies" tool but, althought it is very clear to understand what
queries/tables are related to the query, it does not show de dependencies
graphically.
Is there a function/command/etc that show me graphically how the different
objects in the database are related?. Considering that when I created the
queries I sort of told Access how the different fields related between each
other, can Access create the relationships automatically?.
Hope ypu can help me

Regards
Ignacio

 

[mnature]

I apologize. I should never post before having my first cup of tea in the
morning. You did say that you tried Object Dependencies tool, and I
completely missed that.

To try and answer your question a bit better, as far as I know there is
nothing built into Access that allows a graphical representation of those
dependencies. However, you can import your database into visio pro (tables
and queries), and then use that software to illustrate the dependencies in
your database. This is not automatic (except for the relationships between
tables). You would have to move queries around to show how they relate to
the tables and each other. I have done that, but it was a small database,
and thus fairly easy to do.

 

[Guest]

I apologize. I should never post before having my first cup of tea in the
morning. You did say that you tried Object Dependencies tool, and I
completely missed that.

To try and answer your question a bit better, as far as I know there is
nothing built into Access that allows a graphical representation of those
dependencies. However, you can import your database into visio pro (tables
and queries), and then use that software to illustrate the dependencies in
your database. This is not automatic (except for the relationships between
tables). You would have to move queries around to show how they relate to
the tables and each other. I have done that, but it was a small database,
and thus fairly easy to do.

Excellent! I have Visio Pro!
Thanks for that.

Ross