Friday, March 23, 2012

Multiple Foreign Keys on Same Table

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...Hi,

look here:

http://support.microsoft.com/kb/321843

Perhaps you might have a look on triggers.

HTH, Jens Suessmeyer.

--
http://www.sqlserver2005.de
--

No comments:

Post a Comment