I'm aware that there is already a looooooong thread about creating an audit trail. Here's why I'm posting this new thread.
First of all, the audit trail I have set up (yes, from the thread mentioned above) is only saving the first couple of lines of data--244 characters worth, I think, in the memo field. I found this link about it: http://allenbrowne.com/ser-63.html, but as far as I can see, I don't have any of the issues he listed.
So I did some more browsing around at Audit Trail solutions and found this: http://www.indywebshop.com/bestpractices/2006/07/28/leaving-an-audit-trail-in-your-database/. I REEEEALLY like the idea this guy has, but I got very little sleep last night and unless my brain is just totally shot, I don't think he has an actual working example of said idea.
So my point is, I would like to make an audittrail like the second one, but I have no idea how, nor can I create modules. I would LIKE for the audittrail to be stored in a separate table, since the database is going to be relatively huge with a lot of changes. However, I'm not that advanced with coding yet, and I have no clue where to start.
Does anybody have any suggestions? Or would anybody be willing to give this a go?
Eternally grateful,
Rachel
First of all, the audit trail I have set up (yes, from the thread mentioned above) is only saving the first couple of lines of data--244 characters worth, I think, in the memo field. I found this link about it: http://allenbrowne.com/ser-63.html, but as far as I can see, I don't have any of the issues he listed.
So I did some more browsing around at Audit Trail solutions and found this: http://www.indywebshop.com/bestpractices/2006/07/28/leaving-an-audit-trail-in-your-database/. I REEEEALLY like the idea this guy has, but I got very little sleep last night and unless my brain is just totally shot, I don't think he has an actual working example of said idea.
So my point is, I would like to make an audittrail like the second one, but I have no idea how, nor can I create modules. I would LIKE for the audittrail to be stored in a separate table, since the database is going to be relatively huge with a lot of changes. However, I'm not that advanced with coding yet, and I have no clue where to start.
Does anybody have any suggestions? Or would anybody be willing to give this a go?
Eternally grateful,
Rachel