Auto update history/log

[Guest]

Hello:
Is there a way to auto update a history/log table that is on the many side
of a 1 to many relationship. For example, the connecting field is the Company
ID but if the company changes its name, number, etc, it is manually logged in
the history/log table. Is there a way to auto update the table?
Thanks,
J.

 

[Barry Gilbert]

It's not directly possible in Access. SQL Server has such functionality
with triggers.

If you can, do it from code.

Barry

 

[Guest]

Thanks Barry.
J.