Change Logs
Hello, I'm attempting to create a change log to show the previous and new result changes from 3 tables into a "change log" table. I'm missing something with setting up the relationships I think and...
Forum Discussion
So is the setup this:
In the change log table you have for example:
[Field A Old], [Field A New], [Field B Old], [Field B New], etc?
and each time there is a change, the old an new are supposed to fill in, but if the old and new are the same value, only the new fills in? Is that the current issue?
Yes, that's how I have it set up, with old and new
and yes, that is the issue only the new is filling in and not the old value in addition