Relationship view -table above border

[Ron]

Problem is when I view relationships, a main table is
completely above top border of the window, so can't see
it, nor drag it back into sight, only see the relationship
lines going to it.

The db has 4 main tables & over 10 subtables. So in
Relationship Window I put 2 main tables on same horizontal
level on the outsides, subtables in the middle, then 3rd
main table slightly below 1 side, & 4th below on other
side (notsame level as 3rd table). Saved, but somehow
saving has moved a main table too high to see. Many
subtables relate to more than 1 field in main table, &
also more than 1 main table, so its a complicated design
to print out in easier to understand way.

Thanks for any help - show table just adds 2nd copy of the
hidden main table

 

[Albert D. Kallal]

I think you can use the tab key until the offending table is highlighted.
Then whack the delete key, and then simply re-add the table....

 

[Ron]

Albert,
In this db in Access XP, tab only goes thru tables 1 can
scroll to in the window, not the 1 above the win border.
Thanks for the thought, but I still have the problem.
Ron

 

[RSGinCA]

Is this an April Fools Joke?

Do you have your Access window maximized? If not, then do that.

Can you see scroll bars at the side and bottom of the Relationships window?

Rick

 

[Jeff Boyce]

Ron

I'm with Albert on this. Even if you can't see the table, I suspect you
could click on one of the visible tables, then start tabbing until the
highlight seems to disappear (that would mean it was highlighting your
off-page table).

I might suggest, though, that you click on the relationship line first and
delete it, then do the tab-thing. Once you've eliminated that copy, you can
decide to re-add it, if needed.

 

[John Vinson]

Is this an April Fools Joke?

Do you have your Access window maximized? If not, then do that.

Can you see scroll bars at the side and bottom of the Relationships window?

Nope. It's a real bug I've seen in my own databases, and fairly often
posted in the newsgroups.

In some cases I've had to write code to loop through the database's
Relationships collection and delete the relationships, and then
reestablish them. If manually tabbing from one table to another
doesn't work (it *usually* does for me), I can share that code (it's
easy enough to write).