One of our users has queries set up by a former consultant that uses ACTRANS as the base table and fields from related tables APDISTRIB, CBDISTRIB, and GLTRANS.
Prior to running the queries this month, the user was getting correct data. She doesn't remember making any changes to the query and now she is getting multiple duplicate records. The file was only 6k lines last month and now is 60k.
Are there indices or other parameter settings that restrict the data to not pull duplicates??? I don't create queries linking multiple transaction and distribution tables in MS Addins because of this issue, so I am not able to help.
.dme is attached.
User stated query has always been 400 OTM.
Fields in query are
I do know that the actrans table has a field called the ATN obj id that should be linked to the apdistrib table by the same field which is the apd_atn_obj_id and has a one to many relationship which may cause multiple records.