I am trying to create a BAQ on Cycle Count tags. I’m having trouble with the relationships. I had everything working fine until I added the CCHdr table, then I got duplicates where there were two CCStatus records - one was 1 Started and the second was 7 Cancelled.
I tried having the CCHdr as the top table but Epicor hung. Can someone help me with the correct table layout?
Thanks in advance.