Has anybody created a way to have a bi-directional row-level relationship between two tables in a non-manual way?
I have a set of notes (table) that I reference regularly. One of the columns book(s) is a lookup to a separate table. When I select a specific book from that lookup, I want to have an entry in the book table to reference the notes that I have a relationship to this book. I can do this manually, but I was wondering if there was a way that I could do this in an automated fashion, or by using a formula.
The screen shots below reference both the notes table and the books table.
If anyone can point me in the right direction, this will be a pattern that I will replicate for other Coda solutions.