I created a BAQ to display changes made to the Customer Table. But the report is only showing some of the changes and not all of them. See my setup below.
Did you create a data directive to first track the changes on the Customer table? If so, then the ChgLog table you can filter it on the Table Name without needing to link it to the Customer table in your BAQ.
I found the error, I had the Table relations between ChgLog and Customer with Customer and CustID instead of CustNum. I made the change and it works as expected.