Thanks for your reply Ray.
I recall now that this is similar to, or is, a self join. I used this several years ago on a project and recall doing it but not how. I got the concept but still cannot seem to get it to work.
The code you gave me throws errors and when I fixed it did not give me what I need so I'll try to explain again and simplify.
My table is named:
figure_lines
It has these three columns:
Line_Id, Line_Name, Interest1
(Column Interest1 contains the Line_Id of another row)
I want to display the Line_Name of the selected Line_Id AND the Line_Name of Interest1
So this data:
Line_Id | Line_Name | Interest1
1 | John | 2
2 | Bob | 1
Displays as this:
John Bob
Bob John
I know that I need to create an alias for another table to join and possibly another alias for either the second Line_Name or Interest1 but I am failing and just becoming confused. I'm sure if I can see this done correctly and it works I'll have an ah-ha moment and will write it done for the future. So far it's ah-crap.
Appreciate your time and patience once again.