In a form I want to load a select field with a tree structure i.e parent and child multilevel organization.
table (id,parent_id,label)
values:
1,null,‘A’
2,null,‘B’
3,null,‘C’
4,1,‘A1’
5,1,‘A2’
6,2,‘B1’
7,3,‘C1’
8,7,‘C2’
the result inside the select field should be :
A
L A1
L A2
B
L B1
C
L C1
L C2
and when I select an items I get the id value behind
How can I arrange this in SC5 ?
King Regards