How to retain correct customer address on an older invoice when that address may change later?
Please forgive the likely elementary question, but let's say I'm keeping track of customers, orders and invoices. How do I preserve data in a related record when the original data will eventually change. Ex. I will of course have ongoing records of invoices, but what happens when my customer's address changes? The invoice, by default, is a many-to-one with the customer table, but how is the customer's relevant address preserved on an older invoice if their address changes and is thus updated in the customer table?