Thanks all . I created a DDL trigger and my problem is resolved

Thankyou all.We were able to restore the record .We found that record was missing in one of our main tables.When we restored record into that table ,all the child tables...

can someone help me in writing a query for the described task

all the tables are related to each other in the database,some of them are showing the record but others are not showing it.I will give you an example:

I can see...