Lost Tables in the Relationship Window

  • Thread starter Thread starter Microsoft
  • Start date Start date
M

Microsoft

I have managed to lose two tables off the top of my relationships window.
One is completely beyond the top edge, and the other is half off. The
vertical scroll bar is not recognizing that these objects are beyond the
edge of the window, and the "show all" button changes nothing. The
relationship strings between visible tables and the obscured one are still
attached, but I have no way to access the now invisible end. Is this a bug
or is there a way to get them back? Also why do tables seem to move about
within the relationships window on their own accord? Any help would be
greatly appreciated.

Jake (confused and perplexed newbie)
 
I have managed to lose two tables off the top of my relationships window.
One is completely beyond the top edge, and the other is half off. The
vertical scroll bar is not recognizing that these objects are beyond the
edge of the window, and the "show all" button changes nothing. The
relationship strings between visible tables and the obscured one are still
attached, but I have no way to access the now invisible end. Is this a bug
or is there a way to get them back? Also why do tables seem to move about
within the relationships window on their own accord? Any help would be
greatly appreciated.
Click to expand...

They move around because (I gather) the Microsoft programmers got "too
clever" trying to make the relationships window arrange itself
automatically. It does a bad job of doing so!

I'd suggest setting focus to one of the tables that is on the window,
putting the mouse down, and using the <Tab> key to move from table
icon to table icon. When you get to the ones that are off screen,
press the <Delete> key to delete the icon. This won't affect any
relationships, just the display.

Then use the Add Table icon to readd the tables; the existing
relationship join lines will show up, and you can reposition the icon
where you want it.

A more drastic solution (which might be necessary) is to clear the
window altogether, and click the "Show All" button. This will put all
the tables onto the screen, in a checkerboard grid at random; you'll
need to spend a while moving them around to get a readable display.
 
Back
Top