Using frappe only.
I have “projects” doc, each project has a child table for “phases” ( ie design,build,run,test ). Some projects have many phases and some only have a few. Each phase can have multiple “resources” assigned. ( project manager, developer etc )
I have read that a child form cant have further child forms within it. This is quite a limitation as many complex apps require this multi-level one-to-many nesting
So I attached both the phases and resources docs to the Project doc. But each resource record should be link back to a phase. So I add a phase select in the resources doc. When I do this I get a list of all phases for all projects not just the current ones attched to this projet. So need to "select phases where phase = current docs only phases.
thanks in advance