>Hi,
>I am working on a treeview to display bills of material in a hierachial way.
>All works fine until a part is encountered which is used multiple times on the BOM. It is then not a unique key
>
>How are other folks getting around that problem??
>
I use a prefix, then the PK, then a unique character string. For example,
lcNodeKey = "A_" + TRANSFORM(pk) + "_" + SYS(2015)
Now it's easy to get the PK, just extract out everything between the first two underscores. The prefix identifies the node "type" (usually an identifier for the table).