Update a record in a table that will not affect previous completed records

[ArletteSXM]

Hi,

Im pretty new to this. I created a simple database to record payments. However sometimes creditors change thier personal information such as address or bank account numbers.

If i update thier records, it changes for previous payments which would be inaccurate.

Is there a way to block the completed records; so when i update the creditors information the previous records remain unchanged?

[Seth Schrock]

What method are you using to update the records currently? Also, based on your question, I would say that you probably don't have your database designed well. See Database Normalization and Table Structures.

[Rabbit]

You'll probably want to create a slowly changing dimension so that you can keep track of the changes to the demographic data.

[twinnyfo]

You could also add an "AsOf" date to your Creditors Table. Thus, when you want to look at previous payments, you can link the creditor address to the date on the payment. It complexifies things when you want to maintain historical accuracy on things like this, but very understandable.