If you find this document useful, please consider buying me a
Bi directional links between tables in Coda is possible. It does not work in the way that it does in other products, but it is possible.
In the example below, I have an invoice header and a detail table.
In the Item table, the Inv Nr is a lookup from the header table. The item table also has a column, that copies the text of the Lookup column into the Hid Inv Nr field. In the Header table I filter on the Hid Inv Nr field.
End result is a header table with a list of the Details rows for each Invoice. And a detail table with the invoice details per Invoice Number.