Edit record in Access using textarea in ASP Javascript

[padders01]

I have designed an IT log system. What I would like to do is have an notes field that can be edited, but I want to keep the orignial information in the database.

So for example, I have the following information in the notes field in the Database:

"Spoken to Agent, awaiting for more info"

Then a few hours later I want to update the same notes field but keep the above information

"Recieved screenshot of error"

So in the notes field in the database it shows "Spoken to Agent, awaiting for more info" and "Recieved screenshot of error", not just the last update "Recieved screenshot of error"

Hope that makes sense

[India777]

What About Append Functionality?

In Database write the Following Query when Update:
update Notes set NotesField=Note sField+'Latest Updated Note'

[Pegasus40218]

I would recommend a design modification. Assuming you're creating something of an "Issue Tracking" system, I'd create one table to hold the issue details (including an IssueID field) and then a separate table for logging the notes. In the notes table, I'd inclue the IssueID (foreign key), the name of the person adding the note, the date and time that the note is created, and the text of the note.

[Nicodemas]

Pegasus40218 has the right idea..

[padders01]

Ah yes that is a good idea Pegasus

Thank you