AnsweredAssumed Answered

Relational question and display

Question asked by tcison on Apr 26, 2018
Latest reply on Apr 27, 2018 by philmodjunk

I have a table that is filled with part information:

Part IDPart Name
ID1Name1
ID2Name2
ID3Name3

 

I have another table that shows relationships between parts:

Part ID
Part Name
Related part IDRelated part Name
ID1Name1ID2Name2
ID1Name1ID3Name3
ID2Name2ID1Name1
ID3Name3ID1Name1

 

However, I cannot get the Related part Name to display.  I want to have it come from the part information table so I don't have to maintain both tables if the name changes.  What kind of field would work here?

Outcomes