If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
data diagram
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 |
#2
|
|||
|
|||
data diagram
Check the Relationships toolbar button.
Regards Jeff Boyce Microsoft Office/Access MVP "br549" wrote in message ... 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 |
#3
|
|||
|
|||
data diagram
Hey,
The relationships window, opened by toolsrelationships 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 "br549" wrote in message ... 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 |
#4
|
|||
|
|||
data diagram
OOPS,
With the relationships window open click the "show relationships" button on the toolbar. Mike "br549" wrote in message ... 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 |
#5
|
|||
|
|||
data diagram
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. "Mike Revis" wrote: Hey, The relationships window, opened by toolsrelationships 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 "br549" wrote in message ... 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 |
#6
|
|||
|
|||
data diagram
br549 wrote:
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. -- I don't check the Email account attached to this message. Send instead to... RBrandt at Hunter dot com |
#7
|
|||
|
|||
data diagram
From the database window select toolsanalyzedocumentercurrent
databaserelationships. This will give you a printable report of all the relationships in the db. Mike "br549" wrote in message ... 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. "Mike Revis" wrote: Hey, The relationships window, opened by toolsrelationships 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 "br549" wrote in message ... 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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
ranking query | JaimeTimbrell | General Discussion | 2 | February 16th, 2006 08:09 AM |
Inserting a new line when external data changes | Rental Man | General Discussion | 0 | January 11th, 2006 07:05 PM |
Excel Macro to Copy & Paste | [email protected] | Worksheet Functions | 0 | December 1st, 2005 01:56 PM |
Table Design | A. Williams | Database Design | 3 | April 29th, 2005 07:02 PM |
Pulling data from 1 sheet to another | Dave1155 | Worksheet Functions | 1 | January 12th, 2005 05:55 PM |