[FIXED] How do I avoid foreign key constraint fail error -

Issue

I am currently using dreamweaver and I am trying to insert a record insertion wizard connected to a mysql server. However when I try to update the column I get a foreign key constraint fail and I can understand this is due to me creating a non existent foreign key.But how else can I use an input wizard.

database

Here is the data model. The column I am trying to update is "kommentar" but it is not working, any ideas?

Solution

Tough to say with the info provided, but in all likelihood the value you're using in hotellid doesn't have a corresponding entry in the table hotell.

Answered By - Jason

Answer Checked By - Timothy Miller (PHPFixing Admin)