How to keep track of address changes
I am building a database with a.o. a "Contacts" table, with fields for name, initials, address lines, etc.
I would like to be able to keep some sort of record of address changes. I am envisaging changing the address, as and when necessary, in the relevant "Contacts" record - so that is always the up-to-date one - and would then like to see the old data written to something like "old_address" with a amendment date. These fields do not normally have to be visible; only when specifically requested.
Not having any experience with them, I was wondering if using repeating fields would perhaps be useful in this respect, and if so, how.
But of course, any suggestion to go about this in a different way would be most welcome.