Re: Trigger to update other table produces error 1442

[Simon Giddings]

Hi Peter,

Thank you for taking the time and trouble to answer.

Ok, the first trigger works correctly when put into MySql without raising any warnings or errors (using version 5.0.24 community version).

To answer your question about the reference to client_std.
If you take another look at the brief table spec I gave, you will see that the tables form a chain :
client_prem -> client_std ->client
So, if I want to update client when client_prem is updated, I need to use the chain.

Can you advise as to the correct way to handle this please ?
Simon