I have a requirement. There is a table A, its structure is like this: Col1 Col2 Col3 A A1 20 (10%) A A2 80 (40%) A A3 100 (50%) B B1 40 (20%) B B2 60 (30%) B B3 100 (50%) We know that total of Col3 by Col1 is 200 and each percentage.Now I input 300 through a 'input box' and click submit. If it can calculate in the background and update the records of the table like this: Col1 Col2 Col3 A A1 30 (10%) A A2 120 (40%) A A3 150 (50%) B B1 60 (20%) B B2 90 (30%) B B3 150 (50%) I'm not familiar with maintain language and I couldn't work it out. Thanks a lot for your help.This message has been edited. Last edited by: Elaine,