I have a form like below where there are three columns like -- county , Fips, Housholds 2013. The first two columns county and fips  never change. But the third column Households 2013 will be changed every year. There are around 3,000 rows of data of this form view.

For now all of these  columns are now connected to several forms by anyway in the entire application. below is the form view screenshot :

my question is that what is the best way when I will try to update the Households 2013 column with the updated data by Households 2014 where all other columns data will be same?

 ** If I delete all the data first from this form this action will be automatically executed to other related forms also  so these form will loss the corresponding data.

* Since there are 3000 rows so manually update the households field will be tough and time consuming work.

Sample of Update Households Data:

 

Thanks

Arfater