Gustav Brock
gustav at cactus.dk
Sat Feb 28 03:35:22 CST 2004
Hi John Wouldn't it be much easier to add timestamps and track these? If the timestamp of an address is newer than that recorded for the case, "something else" has changed the address. /gustav > I need a system for watching specific data fields in specific tables for > changes. For example, if the Policy holder address changes, the claimant > address changes, the Payment location (address) changes etc. If ANY of > these change then I need to gather the information and at the end of the day > email a report to the client (the insurance company) spelling out the > changes, what object the fields belonged to (Claimant, Policy Holder etc.).