Hi Friends,

I have new scenario. I have a master detail relation as follows

Head   ID
100     1

Emp    ID   total 
101     1     11     
101     1     10
102     1     10
101     1     10
102     1     10

on display form i have the following format

Emp    ID   total   utilised approved
101     1     11       3      3
101     1     10       
102     1     10       

now when i enter a new value in the approved text feild i want to sum all the columns with same emp no.
ex:
if i enter again 2 in approved column of the second row the result im expecting is

Emp    ID   total   utilised approved
101     1     11       5     3
101     1     10       5     2
102     1     10


Looking forward to your expert advice

Thanks in advance :)