If you are looking for an audit trail solution, check out FoxAudit at www.takenote.com....

>I need to implemet a logging system on a table by table basis and thought to use the insert and update triggers. This seems to work.
>in teh trigger I scatter the fileds to an array and select the logtable insert a record anr write the array into a memo field, replace the user id and datetime and that's it. It works on 8 or so tables but not on the ninth ????
>
>has anubody tried this approach? any better ones??
>
>Thanks
>
>Peter