Posted by FreeToGolfAndSki on 03/25/06 17:41

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: Multiple Foreign Keys on Same Table
• Prev in forum: Multiple Foreign Keys on Same Table
• Thread view: Multiple Foreign Keys on Same Table

[Reply to this message]