DEFINE FILE CAR
BL/A20 MISSING ON=MISSING;
END
TABLE FILE CAR
SUM FST.COUNTRY/A20 AS 'NM'
BY BL AS 'PID'
BY COUNTRY/A20 AS 'UF'
BY COUNTRY/A20 AS 'CD'
ON TABLE HOLD AS HTR1
ON TABLE SET ASNAMES ON
END
-RUN
TABLE FILE CAR
SUM FST.CAR/A20 AS 'NM'
BY COUNTRY/A20 AS 'PID'
BY CAR/A20 AS 'UF'
BY CAR/A20 AS 'CD'
ON TABLE HOLD AS HTR2
ON TABLE SET ASNAMES ON
END
-RUN
TABLE FILE HTR1
PRINT
NM
PID
UF
CD
ON TABLE HOLD AS HTREE
MORE
FILE HTR2
END
-RUN
TABLE FILE HTREE
PRINT
NM
PID
UF
CD
ON TABLE PCHOLD FORMAT XML
END
-RUN

I am trying to load a multi source tree control. The above creates a tree that contains ENGLAND and JAGUAR as separate parent tree items, etc.

What I want is to have ENGLAND as the parent and JAGUAR as the child, etc.

What code do I need to do that?

Fernando

This message has been edited. Last edited by: Fernando, January 15, 2019 09:32 AM