I have a customer table in which some customers have the same parent. Mostly the customer does not have a parent.
How can I create a hierarchy in this situation? I want to show the ChildID as ParentID when no parent is entered in the database. Easy done with an if statement, but I posted the raw data below in the print screen for your reviewing.
I started with Hierarchy (ChildID, ParentID,ClientKey).
ClientKey will be used to link to the name of the client.
I want to display the Parent to child relation in an listbox.
My question: what should the hierarchy statement be to generate the desired List box. With the current statement I don't have a field that acts as as desired