Page 1 of 1

Updating a record while displaying all changes to it.

Posted: Wed Aug 11, 2010 10:11 am
by Brad_Strickland
I don't know if I'm wording this right.
I have a textarea that is entered into a database. When this is edited, I want to store and display a list of all the changes that have been made to it.
Like a conversation in a forum. The reason for this is that I want past changes to be locked from editing.

Would a new database table storing only this text fields data need to be created? Maybe have column for the work request number and a second column for the text entered? But then wouldn't I need an third identifier column so the changes can be displayed in the right order?

Looking for sage like wisdom

Thanks

Re: Updating a record while displaying all changes to it.

Posted: Wed Aug 11, 2010 8:08 pm
by JakeJ
Each entry in to the text box should be kept as a separate record.

It's trivial however to string those records together in the display. I would however have users enter any new entries in a separate text box (one for display, one for entry).