So I need to add internal part numbers (PartXRefInt table) to the Methods Master SSRS report. The table PartRev have the top level part number and there’s an internal part associated with it. My user want this to show up on the Methods Master report. However, the sub component also have internal part cross reference. When I tried to create a relationship from PartMtl to PartXRefInt, it said that I cannot join more than 2 parent table to the same child table. Any ideas how I can reference PartXRefInt more than once from a parent table?
I’ve run into the same issue. If there is a solution to this, please post it.
An Epicor consultant provided a solution. You have to link in additional table(s) to get the proper key fields. For example, I was needing to include the CustXPrt table to the job traveler. So, I needed to add the JobProd and then the OrderDtl tables. Then, I could add in the CustXPrt table and link it to the OrderDtl.
You can try without relationships in RDD, but need to make correct relations in RDL file Dataset query manually.