Easy question I am sure...I am a very newbie...
When I clear the relationships window, does it delete the
relationships?
I ask because when I saved the relationships window, it never asked me
for a file name. Is this like a chalkboard, only one relationship at a
time?
Brendan Reynolds - 29 Nov 2006 16:39 GMT
Clearing the window does not delete the relationships, no, only that view of
the relationships.
You can view multiple relationships in the relationships window. Unlike SQL
Server's diagrams, however, you can have only one view of relationships at a
time. You can not use the relationships window to save multiple views.
Stephen Lebans has some utilities for saving and restoring relationship
window views at the following URL ...
http://www.lebans.com/saverelationshipview.htm

Signature
Brendan Reynolds
Access MVP
> Easy question I am sure...I am a very newbie...
>
[quoted text clipped - 4 lines]
> for a file name. Is this like a chalkboard, only one relationship at a
> time?
Arvin Meyer [MVP] - 29 Nov 2006 16:45 GMT
In line:
> Easy question I am sure...I am a very newbie...
>
> When I clear the relationships window, does it delete the
> relationships?
No, just clears the layout. Show All Relationsships will make them reappear.
> I ask because when I saved the relationships window, it never asked me
> for a file name. Is this like a chalkboard, only one relationship at a
> time?
You don't need a filename becayse they are stored in an internal table
(MSysRelationships) You can print each separate set of relations ships or
save 1 or all as a set. If you add a single table, then choose Show Direct
Relationships, you'll see only the ones connected to that table. Show All
Relationsships will display them all.

Signature
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com
MichiganMan - 29 Nov 2006 18:35 GMT
Excellent! I understand what is going on now, thank you both!