CodingForums.com - View Single Post - "'Cannot add or update a child row: a foreign key constraint fails

Old Pedant · 05-07-2010, 11:29 PM

On top of that, you are trying to add data to a field named cusid in the accounts table but there is no such field as your table was created.

Nor should there be. Links between customer and accounts should go one way. Doesn't matter which way, but only one way.

What I'm more than a little confused by: Why would customer and accounts be separate tables, in the first place???? As your tables are currently designed, each account can have many customers associated with it. Is that your intention???

05-07-2010, 11:29 PM	PM User \| #3
Old Pedant Supreme Master coder! Join Date: Feb 2009 Posts: 23,237 Thanks: 59 Thanked 3,998 Times in 3,967 Posts	On top of that, you are trying to add data to a field named cusid in the accounts table but there is no such field as your table was created. Nor should there be. Links between customer and accounts should go one way. Doesn't matter which way, but only one way. What I'm more than a little confused by: Why would customer and accounts be separate tables, in the first place???? As your tables are currently designed, each account can have many customers associated with it. Is that your intention??? __________________ An optimist sees the glass as half full. A pessimist sees the glass as half empty. A realist drinks it no matter how much there is.