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.
Invoices with Line items
Line item details
There are no rows in this table
Want to print your doc? This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (