AnsweredAssumed Answered

How to keep track of address changes

Question asked by Meulendijk on Apr 23, 2011
Latest reply on Apr 27, 2011 by Meulendijk


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.


Jan Meulendijk