RDD - Multiple Parent table join a child table

(Chai Chang) #1

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?