By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,867 Members | 1,964 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,867 IT Pros & Developers. It's quick & easy.

Edit record in Access using textarea in ASP Javascript

P: 8
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
May 24 '12 #1

✓ answered by 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.

Share this Question
Share on Google+
4 Replies


India777
P: 61
What About Append Functionality?

In Database write the Following Query when Update:
update Notes set NotesField=NotesField+'Latest Updated Note'
May 24 '12 #2

P: 4
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.
May 24 '12 #3

Expert 100+
P: 164
Pegasus40218 has the right idea..
May 28 '12 #4

P: 8
Ah yes that is a good idea Pegasus

Thank you
May 30 '12 #5

Post your reply

Sign in to post your reply or Sign up for a free account.