Home Forums SQL Server 2008 T-SQL (SS2K8) Quertion regarding update when there relationship between two tables RE: Quertion regarding update when there relationship between two tables

  • A foreign key helps you keeping your data consistent. In your case the foreign key says that you can only insert ContactIds in table Contact13 if it already exists in column ContactId of table Contact12.

    So to make your update you need the ContactId 19978 in table Contact12 first.