Posted by gooofy60 on 10/18/06 02:14

I would recommend to create another table to track the history of
updates.

This new table could grow with new entries containing the ID and old
information before update.
It could also hold a date field to track exactly when it was updated.

This will support your current design with the original table being the
most up-to-date information, plus you will be able to list the history
for any entry using the 2nd table.

[Back to original message]