Composite key reference to a foreign key setting problem in sql 2005 Management Studio Express

ssa2010,

In creation of a foreign key constraint, you must refer the foreign key column to the primary key column. Here sicne the key is made of two columns, you have to refer them as a whole and not partially.

If the business doesnt have way for using the two-column key, as a work around can you think about having a check constraint on studid column of Table2 that checks for the existence of the row in Table 1?

---

Thanks,

Jay

<If the post was helpful mark as 'Helpful' and if the post answered your query, mark as 'Answered'>