Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / New Users / November 2006

Tip: Looking for answers? Try searching our database.

Relationships Window Clear/Delete?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
MichiganMan - 29 Nov 2006 15:05 GMT
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!
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.