Hi Everyone,
I am in the kindergarten stage of Sql Server (SQL SERVER 2012) and I need your help in moving forward. I am working a sample database with five tables (
CUSTOMER, TRANS, WORK, ARTIST and CUSTOMER_ARTIST_INT) and have created all the constraints and relationships. My problem is whenever I try to insert data into these tables ( TRANS, WORK, ARTIST and CUSTOMER_ARTIST_INT)
I keep getting error message as seen below:
No row was updated
The data in row 1 was not committed.
Error Source: .NetSqlClient Data Provider.
Error Message: The INSERT statement conflicted with the FOREIGN KEY constraint
" FK_CUSTOMER_ARTIST_INT_CUSTOMER". The conflict occurred in the database "VRG", table "dbo.CUSTOMER",
column 'CustomerID'.
The statement has been terminated.
Correct the errors and retry the ESC to cancel the change(s).
...
Go to the complete details ...