Dear Sir,

Actually there are two tables, table1 and table2
table1 has actual values
table2 has supposed sumed values

table1 has following data

code--dr_amount
--1-----24900
--1-----70200
--1-----71500
--2-----14900
--2-----10200
--2-----11500

Table2 has following data

code--dr_amount
--1-----157360
--2-----35000

I want to display table1 as following to equilize dr_amount in table2

code--dr_amount
--1-----15660
--1-----70200
--1-----71500
--2-----13300
--2-----10200
--2-----11500

there is change in only first record to adjust data according to table2

Please help