Hi,
I am developing VB 2005 windows application using SQL2000. Below are my concerns data hierarchical.
I have 1 table namely "tblLevel" with 2 fields "Parent" and "Child"
Paren | Child
AAA BBB
BBB CCC
CCC DDD
DDD EEE
EEE FFF
FFF GGG
GGG HHH
CCC III
AAA JJJ
CCC KKK
I want to able to get the downlines of downlines and downlines and so on
and after that transfer the result to another separate table which is "tblResult"
I hope some one has big heart to help me and I really greatful appreciating it.
Thanks,
J.R
[/b]
