Support for getting related table contents along with changes of current table.

I have two related tables where change in one tables requires other table's respective data to get complete context. Do you have any use case in these lines? If yes how have you guys solved this problem ? Above changes in the related tables are being done in different transactions.