When creating a tree from a database part of the table is creating the node_id for the branches, now if I understand things correctly these number must be unique in order for the tree to work. Now I have two table tbl_customers and tbl_orders which both use autonumber 0 to 100, now if I create a tree with these tables there will be an error due to both Node_id's being the same. What is the best way of handling this I know I can just *100 the orders to make the numbers different but what happens when the autonumbers get above this number. I have tried using letters in the id but the tree does not like it such as Cus1 and ord1.
Thanks for any help you can give me
Please refer to our Customer Care System submit the reproducible sample of the issue.