Viewing relationships

[Teo]

Hi!
I have a DB that I didn't create.
When I go to look at the relationships, there are like 40 tables, with about
100 relationships (seen with the lines).
Is there another way to print out the relationships between the tables so
that I can use it to improve the DB?
That way I can see which table points where and I'll be able to use it. But
so far with so many relationships on the diagram I can't see anything.

Thanks much in advance,
Teo

 

[John Vinson]

Hi!
I have a DB that I didn't create.
When I go to look at the relationships, there are like 40 tables, with about
100 relationships (seen with the lines).
Is there another way to print out the relationships between the tables so
that I can use it to improve the DB?
That way I can see which table points where and I'll be able to use it. But
so far with so many relationships on the diagram I can't see anything.

Thanks much in advance,
Teo

There are some good third-party relationship viewers - Stephen Lebans
(www.lebans.com) has a good one IIRC.

One just-Access trick is to make a COPY of the database; open the
relationships window and clear it completely. Add one core table and
use the View Direct tool to view the tables connected only to that
table; you can then select each (or some) of them in turn and View
Direct again to crawl out the tree. You can delete table icons from
the window without affecting the relationships; only by selecting the
join line itself can you change or delete the relationship.

 

[Dennis]

John,

Well I visited Steve's site and the file mentioned below did not jump out and bite
me.

Do you happen to know the file name for the "viewer" ?

Thanks in advance!

Dennis

 

[George Nicholson]

My guess is that John was refering to the WindowToBitmap file in the "Other"
section.

--
George Nicholson

Remove 'Junk' from return address.

 

[Dennis]

Thanks Steve!

 

[John Vinson]

Finally I just posted this tonight:
http://www.lebans.com/saverelationshipview.htm
NEW - Jan 21/2004 A2KSave-RestoreRelationshipWindow.zip is an MDB
containing functions to Save and Restore the Relationships View Window.
Allows an unlimited number of different Relationship Window Views to be
saved.

Yet another winner from Stephen Lebans. THANKS!!!!