Table off the Relationship window

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

micromoth - 24 Aug 2006 09:31 GMT

In Access 2003. I set up my tables in the relationship window and
saved them. When I opened next day. One of the tables is not shown on
the screen although I can see the relationship line to it. I have
tried the scrollbar and resizing a number of ways. I just cannot get
it on screen

Any suggestions welcomed.

If it is not fixable, can I delete the whole relationship table and
start again from scratch?

Reply to this Message

Brendan Reynolds - 24 Aug 2006 12:51 GMT

On the Edit menu when the Relationships window is active there is a 'Clear
Layout' command. This clears the display without actually deleting any of
your relationships. You can then display all relationships by choosing the
'Show All' command from the Relationships menu. You'll lose your arrangement
of tables within the Relationships window, but that's all you'll lose. The
relationships will be preserved.

Signature

Brendan Reynolds
Access MVP

> In Access 2003. I set up my tables in the relationship window and
> saved them. When I opened next day. One of the tables is not shown on
[quoted text clipped - 6 lines]
> If it is not fixable, can I delete the whole relationship table and
> start again from scratch?

Reply to this Message

micromoth - 24 Aug 2006 14:01 GMT

Thanks Brendan It worked really well Cheers Graham

> On the Edit menu when the Relationships window is active there is a 'Clear
> Layout' command. This clears the display without actually deleting any of
[quoted text clipped - 17 lines]
> > If it is not fixable, can I delete the whole relationship table and
> > start again from scratch?

Reply to this Message