Need some help/advice storying History

Hi guys, I need some help storing Medical Record history.

Basically I will need any change in a row of data to be stored some
where. All I can think of is to copy the row and the change and re-store
it in the database. Example:

fname: John
lname: Smith
Medical Record Num: 12312312

then they change the number to: 23434333

So now I need to save his old number, when it expired, the new number,
and when it was activated.

Please any ideas would be great. Thank you!

Alex Williams wrote:

Hi guys, I need some help storing Medical Record history.

Basically I will need any change in a row of data to be stored some
where. All I can think of is to copy the row and the change and re-store
it in the database. Example:

fname: John
lname: Smith
Medical Record Num: 12312312

then they change the number to: 23434333

So now I need to save his old number, when it expired, the new number,
and when it was activated.

Please any ideas would be great. Thank you!

I think your approach is very sound. Because you probably do not only
need to record the changes. At some time someone will ask you "how did
the persons data look at <specific-time>".

One way to do this is create your table like this:

records