In query, under tools, query options, record processing there is a "suppress duplicate rows" button. This has never worked. I think it should be designed to suppress duplicate constituent codes as that is the main differentiator in the system.