Many-to-many relationships

Hi! I am new to Coda, having come across it during a search to replace my Android database with an online one. I am a pensioner providing a transport service to school children in the area who attend schools in another area. So basically just fetch then on Frdays at the school hostels and take the back on Sundays.

Before I can start with an online booking form I need to sort out and understand how Coda handles many-to-many-relationships. I currently use a helper table to handle this. This ParentChild table has only 2 fields, for ParentID and ChildID, the key fields for those 2 tables. But how would I connect e.g the Parents Table with a subtable containing the linked child/ren’s data? It probably has to go through the ParentChild table and I do not know how to do that.

I tried to follow this topic How to make relationships automatically apply to parent entries in a hierarchical table? but I cannot open the Game Categories example given in the post.

Any suggestions?

Herman

Hello Herman,

Although Coda is not a relational database, you can connect tables, through relational columns, using filters, lookups, finds (filter() is the preferred method.

Coda is very flexible as far as setting up rerlations, one-way or bi-directional.

If you share a small sample doc to show us what you are trying to accomplish, it is easier to help.

One thing to keep in mind: your database should not become to large for Coda to perform satisfactory. A couple 10K’s of rows still work, but if you need to keep a history of everything that’s happened and if you are dealing with hundreds of children and hundreds of locations, you have to keep an eye on your data collection. I am pretty sure Coda be suitable for what you are trying to do.

Greetings, Joost

1 Like

HI Herman,

Welcome to Coda!

I have put together a few examples of linking tables in Coda on the page Table Joins in the doc below.

Hopefully this helps, but as @joost_mineur said, the best way is to share a doc with what you have so far.

Regards
Piet