This depends upon the primary key of the child table. If a record already exists in the child table with the given foreign key value and the parent record is updated, then a "post update trigger" on the parent table can be written to update the foreign key value of the child table. All key values of the child table must be available to ensure you update the correct row.

If a new record is inserted into the parent table with a new key value, then it would be necessary to have a "post insert trigger" on the parent table to create a new record in the child with the new value. But, this would not work properly unless all non-null and primary key column values were available to insert a new record into the child table.

So, the short answer to your question is "yes, if you have the right information available."

Please complete the following information:

REGISTER / LOG-IN TO DISCUSS

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

Submit your e-mail address below to continue

E-mail: 

E-mail: 

Handle:   

Password: 

Forgot Password?

Create Handle: 

Your handle identifies you in ITKnowledgeExchange. Max 30 char.

Create Password: 

Confirm Password: 

Yes, I agree to the IT Knowledge Exchange  Terms and Conditions.

hidden modal window