>>I want to create a log table so I can trace what the users are doing. What should go in that table. I guess more than 1 table will be necessary.
>>
>>How far should I go with this? I mean I could create a table that contains the name of my forms. and then in the main table have a reference to the form that was accessed or should I go the easy way considering it would be enough and only have 1 table containing only some chars for each action undertaken by the users.
>
>One table should be sufficent. Have the primary key of the Table as a field, a primary key of the Field which has been modified and rest is pretty much standard such as previous value, new value, etc. This requires a Table with all your tables and a Field table with all the fields of each table.
Thank you Michel.
By the way Michel which phone did you buy?
*******************************************************
Save a tree, eat a beaver.
Denis Chassé