Table off the view in Relationship Window

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

Guest

I have one table in the Relationship window that I can't get to. The vertical
scroll bar stops short of it. I see the join lines to it but no table. I
tried closing and opening the database and changing my computer's resolution
but nothing is working. Help...

Thanks in advance.
 
You could try the following:

Move the rest of the tables which you do see to the bottom of the screen
towards the table you don't see. This should activate the scrollbar to go
further down.
Second option would be to delete the join, remove the table and then adding
it again with the add table option and rejoining it with the appropriate
tables.

Best done on a copy of the DB before trying it out on the production version!

hth
 
You already tried my first two guesses.

Go to Relationships on the toolbar and make sure Show All is selected.

Delete the relationship line and bring down the table again. It will
probably have an _1 appended to it. Recreate the relationship.

Try a compact and repair. I'm grasping at straws with that one!

Here's an extreme idea:
1. Back up the entire database.
2. Go to File, Print Relationships while in the Relationships window.
3. While still in the relationships window go to Edit, Clear Layout.
4. Rebuild relationships. No fun there.
 
Back
Top