Hi List.
I've been setting up auditing to track changes in values for forms for a
while. Trouble is, I can't think of an easy way to report on these
changes. For instance, we have a need to find tickets that were in
state X and then transitioned to directly to state Y. We're not using
the Status field for this data, so that is out. The audit form
contains the data, but it is hard to mine. I would have to basically
create a query that shows records in state Y where exists (records in
state X) against the audit form. Then I would need to make the query
more complicated to trim out records where state was X then Q THEN Y...
Or results that where state went in the reverse direction Y to X, etc.
One idea we floated (and it sank pretty quickly) was to create another
form to store FROM and TO values for each modification. The obvious
downfall of this is there overhead in creating the filters to perform
the logic, the problem of data type mismatches if you wanted to use it
as a general repository, and the lack of ability to even push the
DB.value to another form (without storing it first in another local field).
Does anyone have any other suggestions, or is it really just a matter of
creating the query and using sophisticated reporting tools for this kind
of information?
Thanks!
Brien
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
