Using the Same Table in an RDD Twice - Help Needed

[dgreenEA (Dylan Green)]

Situation

I am updating our MTLTag used for non-conformances to include the field PartTran.InvAdjReason if it exists. This field shows the updated non-conformance reason code selected in the Inspection Processing module if it differs from what was listed in the Non-Conformance module. I need to be able to reference the Reason.Description related to the PartTran.InvAdjReason.

Thought Process/Execution

I have tried adding the Reason table into the RDD again but get the following error:

I see in this post that they were able to reference the table another way:

Adding a table twice to RDD for two different purposes

I’m working with a copy of the JobTrav RDD. What I need to do is add some fields from the part for both the raw material parts being consumed and also add some fields for the finished good part being produced. Specifically, I want to add to the PartHeight and UPCCode1 of the ram materials and I want to add the CommercialBrand of the part being produced to the report. I can do either of these by adding the part table. But, after I add the part table for the raw material, it will not allow me …

What I Need

I need more in-depth instructions on how to use the Linked Tables in RDD.

[jeromy (Jeromy Scherbert)]

In the RDD, use the Pick Links tab to select the data you wish to add. Then use the Description Fields tab to select the individual fields.

For instance the JobTrav RDD. First select the table you want to add. In this example I added the PurPoint from the JobMtl table.

Next go to the Description Fields tab and select the field you wish to add. Make sure to select PurPoint from the drop down and then select the field Response to make it available for the report.

Not every table in an RDD will have a list of Linked tables. For instance the JobPart table in the RDD does not have any available linked tables.

[dgreenEA (Dylan Green)]

So in this case the Reason table has no available linked tables listed. Is there no way to add linked tables to it?

[jeromy (Jeromy Scherbert)]

Not that I’m aware of. Have you tried adding the PartTran table and then adding a Relationship?

I’m not entirely clear on what you’re trying to find. Are you trying to find a PartTran record? What Parent table are you planning on using to find the child record?