data diagram

[Guest]

I need to diagram relationships in a database that I inherited from another
user so I can figure out how it works. I'm new to Access. Both in Help and in
the Access book I have (Access 2003 Inside and Out) they describe Database
Diagrams. It looks like there should be a "Database Diagrams" selection under
Objects in the database window. I don't have a "Database Diagrams" option to
select. I can't find "Database Diagrams" in any of the menus. I'm using
Access 2003.

What am I missing here?

I also tried using the Relationships icon -- I add queries and tables to
that view but can never get any of the relationship links to display.

Thanks,
Rob

 

[Jeff Boyce]

Check the Relationships toolbar button.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Mike Revis]

Hey,

The relationships window, opened by tools>relationships or the relationships
icon on the toolbar, is where relationships are created, destroyed and
viewed.

If you have opened the relationships window and there is nothing there then
I
would guess that there are no relationships established.

Adding tables to the relationship window will not establish or display a
relationship that has not been previously created.

Without knowing your table structure it would be impossible to guess at what
the relationships might be.

Sometimes Access will automatically display relationships when you create a
query.

Try making a new query and add a couple of tables to it and see if there are
any relationship lines displayed.

Mike

 

[Mike Revis]

OOPS,
With the relationships window open click the "show relationships" button on
the toolbar.

Mike

 

[Guest]

Maybe I'm not understanding "relationships". When I open the design view of
a query I see several tablesand queries in the upper pane with lines
connecting different fields. I thought the lines connecting the
tables/queries were the relationships.

This database is incredibly complicated, more than 20 tables/queries. There
are so many different links, select queries, crosstab queries, etc that I'm
finding it very difficult to understand the structure of the whole thing. If
I could even just print out what I see in Design View it would help, but
there don't seem to be any print options when I'm in that view.

 

[Rick Brandt]

Maybe I'm not understanding "relationships". When I open the design
view of a query I see several tablesand queries in the upper pane
with lines connecting different fields. I thought the lines
connecting the tables/queries were the relationships. [snip]

Nope those are just "Join lines" used by that specific query. Usually these
coincide with relationships between the tables on those same fields but that is
not a requirement and the creation of joins in queries do not "create"
relationships between the tables.

 

[Mike Revis]

From the database window select tools>analyze>documenter>current
database>relationships.

This will give you a printable report of all the relationships in the db.

Mike