>I nned to create a change log on certain tables. And I think the trigger would be the place to do it.
>Has anyone done that? The logfile should know the table name,fieldn name old value and new value, as well as time and user.
>
>Peter

Yep.. don't forget the INSERT and DELETE triggers. See August 98 FoxAdvisor if you have it.

BOb