Posted by Tom Moreau on 03/25/06 18:20

Don't use the diagram to do this. Use a script:

alter table MyTable
add
constraint FK1_MyTable foreign key (Employee1) references Employees
(EmployeeID)
on update cascade
, constraint FK2_MyTable foreign key (Employee2) references Employees
(EmployeeID)
on update cascade

--
Tom

----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com
..
"FreeToGolfAndSki" <wlr@genoagroup.com> wrote in message
news:1143301309.330185.72720@z34g2000cwc.googlegroups.com...
Hi,

I have an Orders Table that has Employee1 and Employee2 (one is the
sales rep the other is the telemarketing rep) Both of these fields
need to cascade update against the Employees table. I can't seem to
create the desired relationship in a Diagram and I'm not sure how best
to set this up. Any ideas?

Thanks in advance...

• Next in forum: Re: Query/View: The 2 newest periods for each indicator
• Prev in forum: Multiple Foreign Keys on Same Table
• Thread view: Re: Multiple Foreign Keys on Same Table

[Reply to this message]