hello guru's,
at the moment i'm working on a medium database. i have a problem with the foreign key constraints. i created 30 tables and they worked perfectly. now i'm declaring the relations, but i get the error like this:
INSERT statement conflicted with COLUMN FOREIGN KEY constraint 'FK__employee__medew_co__57BDDBAA'. The conflict occurred in database 'new database' , table 'medewerker', column 'medew_code'.
The statement has been terminated.
i know i have to declare the parent-tables first and i did but i keep getting the previous error.
can somebody help me?
greetz,
Telo
at the moment i'm working on a medium database. i have a problem with the foreign key constraints. i created 30 tables and they worked perfectly. now i'm declaring the relations, but i get the error like this:
INSERT statement conflicted with COLUMN FOREIGN KEY constraint 'FK__employee__medew_co__57BDDBAA'. The conflict occurred in database 'new database' , table 'medewerker', column 'medew_code'.
The statement has been terminated.
i know i have to declare the parent-tables first and i did but i keep getting the previous error.
can somebody help me?
greetz,
Telo