Trying to create a change log to track Menu security changes. I can track new record and update, but cannot track deletion. I tried looking around, but do not see an option and the checkbox is grey out. Any ideas how to track deleted records?
You can’t with the change log as the change log row is attached to the record. When you delete the record, the entire log goes with it.
What I have done was write the changes to a UD table. Anytime an add/update/delete happens, push certain fields to UDXX.
2 Likes
Thanks for the suggestion. Will look into a UD table.
Shouldn’t have to customize for this. If you agree please vote: