I have two source tables. The second table uses the first to identify its rows. (Basically this is the “toy” subset of my intent of using one identity table and as many smaller details tables as I need to relate more data to it later.)
Now, I want to create a table that brings these two source tables together. It’ll be a Natural Join as one of the source table’s rows are identities on the other. Lookups are the Coda way of doing this. I setup a Lookup column for the first source table and could pull referenced columns just fine. Now I set up the second table’s Lookup column, and thought I could just use a formula to reference to the first table’s relevant row with
thisRow. It doesn’t throw me any errors, but simply doesn’t work.
Surely, this is the most intuitive way to Join tables in Coda? I can’t possibly manually pick the correct reference for every single source table I’m eventually going to create. What am I doing wrong?
Here’s the example table with more detailed writeup: