Parent Child relationship

[et21]

Hi all,

I have a parent child projects like below

Project 1
==> Project 1.1
       ===> Project 1.1.1

I want to display all of that projects that under Project 1. is there a way to do that?

TIA

[dougp]

Maybe provide query subject and query item names so there is less translation from my guesses to your actual solution.

One level deep?  That's easy.  Role play your Project query subject as ChildProject.

Queries:
Project
ChildProject - copy of Project
output - join Project and ChildProject on Project.ProjectNum = ChildProject.ParentProjectNum

All levels?
The query will need to use SQL written as a recursive CTE - probably using the pass-thru option.


Create visualizations as needed.