Advice

[Chris]

I was wondering what the best way to set up the following scenario.

When a person has moves home, his new address is entered and the current
address should be marked as old address.

So is the best way to set this up?

?s it better to transfer the address details into a previous address table
or to have all addresses in the same table and marked as previous/current
address.

 

[Van T. Dinh]

Same Table.

A Field indicating whether it is the current address or not is fine.
Alternatively, you can use the "EffectiveFrom" date field and use the
address with the latest effective date as the current address.

 

[B. Comrie]

Create an Audit Trail (history of changes)

http://www.codewidgets.com/product.aspx?key=89

 

[Douglas J. Steele]

Or you could get code for free at
http://members.iinet.net.au/~allenbrowne/AppAudit.html