Update new address & archive the old ?

[Negger]

Hi, Unsure as to how to proceed with updating addresses. DB now contains some 750 records. Members addresses are stored in six separate Fields in Table, (House name, Street,District,Town,Postcode etc.)& input is by way of an Input Form.
I'm not sure how to proceed if a member changes address, as I need to maintain a record of previous addresses for upto 7 years, so it may be quite possible to end up with 2 or even 3 previous addresses.
Presumably I will enter a new address into a "ChangeofAddress" Input Form and store in a new record ?
However, how do I have the input form display the correct Member in the name fields, (without creating a duplicate name record?) but then store newly entered address into a NEW record, rather than overwriting the old ?
Also I would need all my Forms/Queries/Reports etc. to display the new address by default, and only call up the previous address if specifically requested. I presumably need to link the Member Record ID to the new address record ID ?(1 to Many ?)
Add a Change of Address Date Field ?
Add a Change of Address Date Field2, & 3 ?
Any assistance and/or a link to a detailed explanation of how to achieve this would be much appreciated.

 

[Negger]

Thank you Pat. I will try to follow your suggestion! On a general point, I had the idea that "normalisation" involved keeping all data of a similar type e.g. Addresses, within the same Address_Table. Your solution will obviously involve similar data held in PreviousAddress_Table.
That will be OK presumably ?
Regards