Hierarchy without parent ?

[Michiel_QV_Fan]

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

[Anonymous]

WHEN THE DATA  LOAD THE TO NEXT BUTTON MULTIPLE TYPE AT THE STAGE HAVE CROSSTABLE AND HIRCHACHY TO GIVE THE HIERCHAY

[avinashelite]

If you don't have the Parent ID then your approach is rite