Hierarchy National

[marcohadiyanto]

hi,

i have problem with hierarchy, i want to show National-Area-Branch.

i have AreaID , AreaName , BranchID , BranchName coloum.

in table Area, i have all that coloum.

Hier:
Hierarchy (BranchCode, AreaCode, BranchName,AreaName,BranchName,Path)
LOAD
 BranchCode,
 AreaCode,
 BranchName,
 recno() as recno
RESIDENT Area;
drop Table Area;

this code just show for Area and Branch, but how can i show it for National (total area). please advice.

Thanks

[marcohadiyanto]

anyone can help me?

thanks