I was given this task. There are 14 fields in a record, 7 fields have this years data, 7 have last years data. Each year, for numerous years, someone would export and dataload the current years data into the last years fields and a user would input the current years data in the current year fields. The fields are in a single double column section in a layout.
Now, they want the ability to add multiple rows for the current year fields in a table form going forward and also show last years values. They only need current and previous years, not more.
They want the ability to edit the current years data and just view the previous years data.
If I was clear in explaining this, how to set this up? VF is fine but explain how to store the data and how to display it.