How to Display Inspection Data from the rcvdtl Table With Fields from the DMRHead Table

I am trying to create a BAQ to pull inspection data. I want to pull in all the part info from receiving tables and have the DMR number and comments show for the rejected items. When I get the data back it populates the DMR number and comments for each instance of the part not the rejected part.

I set up the query as mentioned above. The query is not pulling data for any fields from either of the DMR tables. If I reverse the join I can get the DMR table data but not the RcvDtl data. any thought?

I removed the "First" qualifier from the DMRActn and it generates this message when tested: Table: , Level:, Type: , RowID: , Text: Business Query Execution error. Please contact your System Administrator.

I switched the qualifier back to "First" from "Each" and the query will run, but it is not displaying data from the PackSlip or Packline fields. This is true for both the RcvDtl table and the DMRActn Table. If I reverse the joins I do get data for the PackSlip and PackLine feilds from the RcvDtl table, but not the DMRActn table.

Basically I can get data from the RcvDtl table to display and if I reverse the joins I can get data from either of the DMR tables, but not from both the DMR tables and the rcvDtl table.

When I tried linking the DMRHead to the RcvDtl table I was able to get data from both tables, but it would pull an existing DMR Number into to the field of accepted parts if the particular parts had been rejected in a previous receipt record.

My goal is to be able to get certain data from the RcvDtl table and the DMR tables to create a file that can be uploaded in to an access database that generates custom reports and charts used for rating the quality of our suppliers parts we receive.

You can use ODBC but if the links do not exist in the data. You will not be able to narrow down the returned data. You would have the same problem with ODBC as you original request.
If the only link is by Company, Part and Supplier the DMR will lnk to every Receipt for that Company,Part, Supplier. I was trying to link pack slip to get the correct receipt.
Since the data does not exist that will not work.
I do not see any other way to narrow the DMR to the Correct Receipt.