Re: Am I not understanding auditing?

[Brien Dieterle]

** I thought I understood auditing, but now you've made me confused :-) I add a table field to my original form and point that to my audit form and use a qualification to match a unique key.  Then my table field always shows the previous values, who, what, and when, etc.  Pretty slick. I haven't used a log form but I see they allow three "log keys" that you could insert maybe $SCHEMA$ and request ID to provide the unique combination of keys to allow what I described above. Hope that helps! Brien R. Alan Monroe wrote: No, you're not missing anything. I completely agree with you; it's a bit lacking in its current implementation. I think it would be much more useful if auditing included both the old and the new value. However the auditing as it is currently designed only records the new value. You would have to get the previous value by finding when it was set to the previous value in a prior log entry. Oh well, back to writing a giant stack of filters, then. Alan _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are" _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_