Hi @Andrew_Malcolmson and welcome to this community!
I’d suggest you to consider Coda more on a object-oriented philosophy rather than a key-based relationships.
Please, have a look at this simple example based on your use-case.
As you can see, you query your data by providing the actual “object” (i.e.
Row), rather than a key.
this also simplifies dynamic filtering when building up views.
Note that I just added
ID columns for the sake of the relational heritage, but they are not really needed.
Let me know if this helps.
If you really need and want ID references, you can still build up your filter like this:
e.g. “retrieving the Customer of the first Order”:
[or the equivalent
or “retrieving all Orders of the first Customer”