When executing the query it presents the error below
the insert statement conflicted with the foreign key constraint “FK_CaseClient. The conflict occurred in the” TESTER "database, table dbo.Case, Column Id
When executing the query it presents the error below
the insert statement conflicted with the foreign key constraint “FK_CaseClient. The conflict occurred in the” TESTER "database, table dbo.Case, Column Id
You have defined column Id as primary key and in insert query you’re not passing any values to the primary key field.
If your Id is auto incrementing make sure the new Id will exist in the Case table.