LB
2 years agoQrew Cadet
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...
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?