AnsweredAssumed Answered

How to retain correct customer address on an older invoice when that address may change later?

Question asked by DanF on Dec 18, 2010
Latest reply on Dec 20, 2010 by philmodjunk

Title

How to retain correct customer address on an older invoice when that address may change later?

Post

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?

Thanks!

Outcomes