Hello Access Experts! I have a database with several tables. I have a form that I have setup based on a data table called tblForecastMaster. I need to be able to create a copy of each record that gets modified.
The reason I need to do this is because we need to show the original record that we...
I have an asset tracking database to record what asset is assigned to what person. Now I am interested in making a 'real-time' history for each asset.
When any field changes on a record the record is copied to a table to inlcude date of record change.
Any clue how to do this?