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.
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.