hi..i have 2 tables client and user and between them it's a relationship 1:1 and i'm trying to insert a new client but i get the error: the insert statement conflicted with the foreign key constraint "FK_client_user"...etc i understand why, but i don't know how to solve it. i've thought that first i should introduce a blanc row in each table then replace the values..but i don't know how to implement that, another solution? pls i need some help.
the tables structure is:
client(client_id(pk), user_id(fk), client_type etc)
user(user_id(pk), client_id(fk), password, email)
Loading

Harekrushna ParidaPosted Mar 22, 2013, 3:55 AM
If that key is not present in mapped table then this error usually throws by system
Harekrushna ParidaPosted Mar 22, 2013, 3:55 AM
If that key is not present in mapped table then this error usually throws by system
Harekrushna ParidaPosted Mar 22, 2013, 3:55 AM
If that key is not present in mapped table then this error usually throws by system
Arul ManivannanPosted Mar 22, 2013, 3:30 AM
Violeta PopaPosted Mar 21, 2013, 10:19 AM
Arul ManivannanPosted Mar 21, 2013, 9:22 AM
The column name user_id in Client TABLE is unnecessary. So remove that column first.
Arul Manivannan