I have a table (let’s call it table1
) that has a primary column called table1_id
I then have another table (let’s call it table2
) that has a column which is a link to that table1_id
value.
I then have another table (let’s call it table3
) that has a column which is a link to that table1_id
value.
How do I create a column in table1
that looks-up a value from table2
based on the row that table1_id
is linked in. I feel like I need to do a lookup, but I can only do that on linked Values.