• 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