link table

#1

I am new to SQL Server 2000 and I would like to link tables the way I would
in Access. How can this be accomplished?

#2

SQL Server is quite different. Open Enterprise Manager, Right click on table
name in right-side pane, go to Design Table, in the screen that opens in the
top toolbar, go to Manage Relationships.
In Properties Window, click on "New" to create a new "link" and then select
appropriate table and column(s) below.

Regards,
Ilona Shulman

"Jeff" <Jeff (AT) discussions (DOT) microsoft.com> wrote

Quote:

I am new to SQL Server 2000 and I would like to link tables the way I
would
in Access. How can this be accomplished?

#3

Or alternatively if you _MUST_ use the MS Access look then create a new
diagram and add the tables you want. Then drag and create the
relationships.

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.Konesans.com

"ilona" <ilona_scrambled (AT) no-go (DOT) com> wrote

Quote:

SQL Server is quite different. Open Enterprise Manager, Right click on
table
name in right-side pane, go to Design Table, in the screen that opens in
the
top toolbar, go to Manage Relationships.
In Properties Window, click on "New" to create a new "link" and then
select
appropriate table and column(s) below.

Regards,
Ilona Shulman

"Jeff" <Jeff (AT) discussions (DOT) microsoft.com> wrote in message
news:7208C3A9-DDB5-4F89-89A0-A5ABEC14A94F (AT) microsoft (DOT) com...
I am new to SQL Server 2000 and I would like to link tables the way I
would
in Access. How can this be accomplished?

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

link table

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

link table - 10-12-2004 , 09:17 AM

Re: link table - 10-12-2004 , 11:08 AM

Re: link table - 10-13-2004 , 01:06 PM