data diagram

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
Check the Relationships toolbar button.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
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
 
OOPS,
With the relationships window open click the "show relationships" button on
the toolbar.

Mike
 
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.
 
br549 said:
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]
Click to expand...

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.
 
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
 
Back
Top