BAQ to join RcvDtl and DMRHead

Yahoo Archive
1
I am trying to create a DMR tag that will print out a tag to identify product that failed a PO inspection and is going into DMR. The tag needs the following information: PN, REV, Inspector, POnum/Line/Rel, DMR #, DMR Qty, Insp Date, and Reason Code.

The information is all stored in the RCVdtl table EXCEPT for the DMR # itself. Look at the DMRHead table I cannot find a way to link back the RcvDtl.

We are on 9.05.604A.

Any suggestions on how to do this?

Thanks,

Tom