Drop Table

Support Forum for database administrators and web based access to important newsgroups related to databases

For Database admins: Free Database-related Magazines Now Free shipping to Texas

Database Topics > MS SQL Database Server > Microsoft SQL Server forum >

Multiple Foreign Keys on Same Table

Thread

Author

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