is there a tool to display relationships between tables

[Roger]

I've moved all my tables to sql server2005 and I've created the
appropriate relationships
now I create links to two such tables that have a relationship into ms-
acess97
but when I add the two tables to the 'relationship' window, it appears
as though my odbc dsn link doesn't bring across the relationship(s),
so I just see two tables

sql server has a 'diagram' , is that the best tool, or is there
another ms-product that works better ?

[MGFoster]

Roger wrote:

I've moved all my tables to sql server2005 and I've created the
appropriate relationships
now I create links to two such tables that have a relationship into ms-
acess97
but when I add the two tables to the 'relationship' window, it appears
as though my odbc dsn link doesn't bring across the relationship(s),
so I just see two tables

sql server has a 'diagram' , is that the best tool, or is there
another ms-product that works better ?

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

There cannot be formal relationships between tables in 2 different DBs,
that is a distributed DB and MS Access can't handle that; nor, I
believe, can SQL Server.
--
MGFoster:::mgf00 <atearthlink <decimal-pointnet
Oakland, CA (USA)
** Respond only to this newsgroup. I DO NOT respond to emails **

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBR+nutIechKqOuFEgEQKIvACgvRNUkc5HniXG4M2770UO9H Y2cXcAoOX0
CI5I0O9WVhvUhj8BM8Oooui9
=Umll
-----END PGP SIGNATURE-----

[Roger]

On Mar 26, 12:35*am, MGFoster <[e-mail]:

Roger wrote:

I've moved all my tables to sql server2005 and I've created the
appropriate relationships
now I create links to two such tables that have a relationship into ms-
acess97
but when I add the two tables to the 'relationship' window, it appears
as though my odbc dsn link doesn't bring across the relationship(s),
so I just see two tables

sql server has a 'diagram' , is that the best tool, or is there
another ms-product that works better ?

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

There cannot be formal relationships between tables in 2 different DBs,
that is a distributed DB and MS Access can't handle that; nor, I
believe, can SQL Server.
--
MGFoster:::mgf00 <atearthlink <decimal-pointnet
Oakland, CA (USA)
** Respond only to this newsgroup. *I DO NOT respond to emails **

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBR+nutIechKqOuFEgEQKIvACgvRNUkc5HniXG4M2770UO9H Y2cXcAoOX0
CI5I0O9WVhvUhj8BM8Oooui9
=Umll
-----END PGP SIGNATURE-----

all my tables are in sql server... so I'm not trying to implement
relationships across databases

I just want a way to graphically view the tables / relationships like
the 'relationships' function in ms-access

and like I stated, sql server has a 'diagram' function that looks
similiar, it's just bulky to work with