I have a parent - child hierarchy and I have looked to other posts about hierarchybelongsto etc. But I can't seem to figure it out.
My data looks like this; I have different categories; organisation, employee, customer, account etc. Which are all linked to 1 center scheme. Every of the categories has a parent child hierarchy which is Parent<namecategorie>ID, <namecategorie>ID, <namecategorie>Name.
How can a get a listbox per categorie with the hierarchy drill down? So the Name of the parent (for example ABN AMRO) and if I drill down the name of the underlying (for example ABN AMRO Banking, ABN AMRO Real Estate etc.)
I attached the file hope you guys can help!!