data diagram

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

br549 - 24 Feb 2006 23:25 GMT

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

Reply to this Message

Jeff Boyce - 25 Feb 2006 00:52 GMT

Check the Relationships toolbar button.

Regards

Jeff Boyce
Microsoft Office/Access MVP

>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
[quoted text clipped - 14 lines]
> Thanks,
> Rob

Reply to this Message

Mike Revis - 25 Feb 2006 01:13 GMT

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

> 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
[quoted text clipped - 11 lines]
> Thanks,
> Rob

Reply to this Message

br549 - 25 Feb 2006 16:21 GMT

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.

> Hey,
>
[quoted text clipped - 39 lines]
> > Thanks,
> > Rob

Reply to this Message

Rick Brandt - 25 Feb 2006 17:19 GMT

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

Signature

I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

Reply to this Message

Mike Revis - 25 Feb 2006 17:20 GMT

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

> 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
[quoted text clipped - 50 lines]
> > > Thanks,
> > > Rob

Reply to this Message

Mike Revis - 25 Feb 2006 01:29 GMT

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

Mike

Reply to this Message