<div>
no.<br />
you need to implement this using a trigger
</div>


no.
you need to implement this using a trigger

<div>
&gt;&gt;angelIII<br />
<br />
My problem is that I have an exisitng FK constraint to a PK table, and since I want to use the existing FK table for another purpose, and I don't want to remove the existing constraint, I thought it would be excellant if it could modify this constaint to make it map to 2 PK tables<br />

</div>


>>angelIII

My problem is that I have an exisitng FK constraint to a PK table, and since I want to use the existing FK table for another purpose, and I don't want to remove the existing constraint, I thought it would be excellant if it could modify this constaint to make it map to 2 PK tables


<div>
&gt;&gt;angelIII<br />
<br />
Ahaa...I see...thx for your help!..<br />

</div>


>>angelIII

Ahaa...I see...thx for your help!..


<div>
<div class="content wysiwyg-content">
Hey experts,<br />
<br />
&nbsp;Can I have a foreign key constraint that states that field x in foreign key table a can map to field y in primary key table b OR field z in primary key table c....usually the constraint is only between 1 FK table &amp;&nbsp;1 PK table (and not 2)...so can the above be done??<br />

</div>
</div>


Hey experts,

 Can I have a foreign key constraint that states that field x in foreign key table a can map to field y in primary key table b OR field z in primary key table c....usually the constraint is only between 1 FK table & 1 PK table (and not 2)...so can the above be done??


FK constraint that can map to 2 PK tables

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.