i’ve created a table that holds a field wich is a list of same elements and a field for parent record.
As to create a hierarchy of same elements :
- Name - Text
- Children - List of Tables
- Parent - Table
So, in my Table, i have some “head” elements where Parent is empty, and some of those “Parents” have several children (each children having in its Parent field a reference for its parent).
My thing is how can i display in a Repeating Group the very same hierarchy this way :
- Parent 1
- Parent 1 - Child 1.1
- Parent 1 - Child 1.2
- Parent 2
- Parent 2 - Child 2.1
- Parent 2 - Child 2.2
- Parent 2 - Child 2.3
- Parent 3
- Parent 3 - Child 3.1
and so on …
Doing a Merge doesn’t match as the list wouldn’t be sorted by the parent’s name.
i tried what @NigelG’s LEFT OUTER JOIN (SQL Joins Vs Bubble) but that wouldn’t do it neither as i won’t have just the parent (i’ll have Parent + all of its children).
And, i’m not familiar enough to see any other option…
Any idea ?