another challenge I am facing
I have three tables:
Table 1 - DB_project: showing all projects based on a projectID
Table 2 DB_milestone: showing all milestones based on a milestoneID and connected to table 1 via the projectID
Table 3 DB_todo: showing all todos based on a taskID and connected to table 2 via the milestoneID
I am now trying to show a repeating groups which shows the number of milestones of a project (done!) and the number of total todos of a project (problem )
Basically, I am basically trying to count all todos which are related to milestones, which are related to one project.
I have tried it with setting up a search within a search, such as :
… but that does not work so far.
I cannot get my head around how to put the Do search and :count algorithm together to achieve that.
Anybody has any idea to help me out?