Transaction Log - Can ID# be converted to Field Contents?

[MHadden]

I am currently using the transaction log(faq181-291) (By: Michael Red) to keep track of changes to records. This works great, but it keeps track of the changes by the unique ID #, and I am interested in using other fields. In other words I would like to be able to view changes based on the name on the record. EXAMPLE: Index = FirstName & LastName, or something similar to this. Any ideas would be greatly appreciated.
Thanks in advance,
Michael
MichaelHadden@AltaVista.Com
If you give someone a fish, you have given them a meal. If you teach someone to fish, you have given them MANY meals!

 

[MichaelRed]

M. Hadden,

I do not know of any general soloution (e.g. be able to arbitrarily switch the Key field), however as a specific process, all you need to do is include the new "Key" in each transaction record (as a field). this could be either as areplacement for -or an addition to- the existing information.

To be able to do arbitrary field searches, you would need to save the entire record for each change. This COULD be done, either by saving a record for every field in the transaction log, or -probably more effectively- by saving the (entire) record for each transaction. If you were to save hte entire record, you may want to also include a mechanisim to note the field(s) which were changed.

MichaelRed
m.red@att.net

There is never time to do it right but there is always time to do it over