I have a table that is filled with part information:
|Part ID||Part Name|
I have another table that shows relationships between parts:
|Part ID||Part Name||Related part ID||Related part Name|
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?