Auto update history/log

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
It's not directly possible in Access. SQL Server has such functionality
with triggers.

If you can, do it from code.

Barry
 
Back
Top