Track data changes in Records

[Ezequiel Navarro]

Does Access have the ability to track the changes made to
a record's data?

For instance, if an employee's title is edited, is there a
way to retain the original entry, and any subsequent
changes to the data in the employee title field?

It's establishing a history file for each record which can
later be reported.

Anyone???

 

[Nikos Yannacopoulos]

What you have here is a classic case of one-to-many
relationship, i.e. a given employee may have many
different job titles over time (or he/she should seriously
think over their carreer!).
The proper way to deal with this is to (a) remove the
job_title field from your Employees table, and (b) create
a new table (e.g. Employee_Title) with a foreing key
Empl_No, create a reletionship on this field on the main
Employees table, and keep the title information here. This
will allow you to keep several job titles per employee.
If you do so, I would suggest you also add a field
Starting_Date in this table, so you can have the full
history.
Obviously, you could do the same with salary, company car
use etc (preferably in different tables, as the dates will
not necessarily coincide).

Nikos Y.