Stuart McLachlan
stuart at lexacorp.com.pg
Mon Jun 21 16:56:39 CDT 2004
On 21 Jun 2004 at 14:28, Jim Lawrence (AccessD) wrote: > David: > > If the client wants to see all changes to a record on a field by field bases > then the/each transaction file(s) will have to have a minimum of a complete > copy of each record structure of each table or at least any field that a > user can affect. Not necessarily. I've fallen into that trap before. Why save 200 fields when only 1 changed. For many environments, it's quite sufficient to just store: "FieldName,OldValue,TimeStamp,Operator". -- Lexacorp Ltd http://www.lexacorp.com.pg Information Technology Consultancy, Software Development,System Support.