Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Problem with Relationships window

Status
Not open for further replies.

pandamonster

Programmer
Aug 12, 2003
1
US
Hi, I'm having trouble getting the relationships window in Access to display my relationships. I recently ran the Performance Analyzer on my database and it recommended that I create a relationship between two of my tables. I let it do so and now, when I open the relationships window, it doesn't show any of my relationships unless I manually click "show direct" for each table. "Show All" does nothing. I've tried deleting the relationships and re-creating them, but it does no good. It doesn't seem to make any difference in terms of the performance of the database, but it is disconcerting. Does anyone have any idea what's going on?
 
If the table is not displayed in the relationships window, the relationships to that table will not be displayed. The relationship still exists, but is not shown.

Add all of your tables to the diagram and the existing relationships will be visible.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top