Relationships Window Clear/Delete?

M

MichiganMan

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?
 
B

Brendan Reynolds

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
 
A

Arvin Meyer [MVP]

In line:

MichiganMan said:
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top