I have a serious problem. I am trying to update an entry in a parent table which has three children tables which are coupled in such a way that either on delete or update they are affected.

What I want is to know if there is a way to update a parent node without having the change effect the data in the child tables either via sql or the query browser without altering the tables in any way.

I plan to resolve this problem later on when I have some time to work on it but I need a quick fix for now.

Let me know if I you need more explanation on this as I am sometimes very difficult to understand.

Can anyone help?