Fortunately I have solved this problem. I think it was something about being a two field composed foreign key and updating these two fields at the same time gave some kind of error.
I solve it by adding a temporary row in the referenced table with one of the fields already changed and then updating this field in the referencing table. Once this field has been updated, then I perform an update to the second field in the referencing table. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]