If you had:
You could have a replica:
Then, using an After Update table macro, you can make it Create a record and Set its fields. With that, each modification to your record is inserted in the history table and you'd have a history of changes that you could browse using a subform. It's a friendly approach.
Edit: grammur and stuff
Code:
tbPeople:
PersonID
FirstName
LastName
You could have a replica:
Code:
tbPeopleHistory:
Id
PersonID
FirstName
LastName
Then, using an After Update table macro, you can make it Create a record and Set its fields. With that, each modification to your record is inserted in the history table and you'd have a history of changes that you could browse using a subform. It's a friendly approach.
Edit: grammur and stuff
Last edited: