as i explained before i received docno with different transmittalno and then send them by different transmittaltoCon.
docno is parent of transmittal and transmittal is parent of transmittaltocon.
for excample
today i recieve (doc-001) revesion 1 with transmittal tt-001 and send it by transmittaltoCon (con-005),(con-009)
after tomarrow i recieved (doc-001) revision 2 with transmittal tt-800 and send it by transmittaltoCon (con-1000,con-2000)
so in the treeview docno is level1 and transmittal is level2 and transmittaltoCon is level3
doc-001
|
|
------tt-001----------
| |
-----con-005
| |
----con-009
|
-------tt-800 |
|-----con-1000
|----- con-2000
now i need parent and position value of each field/node in the query