We manage the relationship and can therefore do what you’re asking without having to create a new relationship (which we recommend you not do) from the parent to the child.
We recommend all relationships go from child to parent as in, what belongs to what. For example, each task belongs to a Project, therefore, create the connection from the Task to the Projects. When you do it this way and then go into the Projects table you’ll be able to add fields that can summarize “Total Tasks” from within the Projects table.
There are many other benefits of doing it this way:
- Inside of forms when adding a task you can dynamically show fields from the Project table inside a form.
- Inside a table in your live app you can add any column from the Projects table inside of your Tasks table.
You can see here an example with different tables, but same concept. Choosing the Parent will enable you to dynamically see values from that table:
Taken from here:
It’s a bit of a adjustment coming from traditional databases to this architecture but ultimately nearly anything possible in traditional databases will be possible here - simply requires a bit of a paradigm shift.