>> updating parent table using lookup child table i get the error
I'm not completely sure what you're trying to do here. It sounds as though you're trying to update the primary key value on the parent table. If there are related child records, this would result in this error.
If this is the case, one way to resolve this would be to "cascade update" the child records. The "ON UPDATE CASCADE" section in this article describes this in more detail.