Hierarchical List box Question

I know how to make a simple Hierarchical listbox from the Language reference example but, I want to go beyond that and would appreciate any coding help/examples.

Here’s what I want to do…

I have one listbox with 3 or 4 columns of info which is populated from a MySQL data table called PROGRAMS

Each Program has either one or multiple OFFICES. I can display a second Listbox of the Offices but…

I would like to use the Hierarchical feature if possible so that a user can expand/drill down on a given Program and display the list of offices (which is also populated from another MySQL table.

Hi Rick - have a look at this.

This is what I see when I clidk on your link…

RbBF?????????2>ÔBlokProj??????PSIVStrn???2013.041ACnmStrn???AChpStrn???ACsvStrn???Ver1Strn???1 Ver2Strn???0 Ver3Strn???0 RelsStrn???0 NnRlStrn???0 RegnStrn???SVerStrn???LVerStrn???IVerStrn???aiviInt ???DVewInt ~­ÏÿprTpInt ???DLanInt ???CLanInt ???DEncInt ???BflgInt ??I?UsBFInt ???prWAInt ???IconGrup????ÝÑEndGInt ?ÝÑMacCStrn???BCarStrn??? lbexample BCMOStrn??? lbexample BunIStrn???nz.co.axisdirect.lbexample BSizInt ?@??BMSzInt ? ??BSzSStrn???4096BMSSStrn???2048MDIcStrn???BWinStrn???
lbexample.exe BMDIInt ???WcmNStrn???Axis Direct Ltd WpNmStrn???WiNmStrn???WiFdStrn???GDIpInt ???BL86Strn??? lbexample DgCLStrn???WprtInt ???WptSInt ??»WpclInt ???WdptInt ??WbsrInt ???WbLSStrn??? Launching…WHTMStrn???WbDSStrn???:The application has gone off-line. Please try again later. PadnPadn???¬****************************************************************************************************************************************************************************BlokpObj%«Ÿÿ??????NameStrn???App ContInt ???paswStrn???bClsInt ???SuprStrn??? Application flagInt ???bNtrInt ???bApOInt ???CompStrn???PDefGrup???D?ÝÒnameStrn???aMenuBar typeStrn???aInteger visiInt ???PValInt <Ž÷ÿEndGInt ?ÝÒVwBhGrup????ÝÓEndGInt ?ÝÓCnstGrup???ÝÔnameStrn???kFileQuitShortcut CompStrn???VsblInt ???EncoInt ??nameStrn???kFileQuitShortcut typeInt ???defnStrn???flagInt ???CInsGrup???0?ÝÕpltfInt ???langInt ???defnStrn???Cmd+Q EndGInt ?ÝÕCInsGrup???0?ÝÖpltfInt ???langInt ???defnStrn???Ctrl+Q EndGInt ?ÝÖEndGInt ?ÝÔCnstGrup???Ì?Ý×nameStrn??? kFileQuit CompStrn???VsblInt ???EncoInt ??nameStrn??? kFileQuit typeInt ???defnStrn???&Quit flagInt ???CInsGrup???0?ÝØpltfInt ???langInt ???defnStrn???E&xit EndGInt ?ÝØEndGInt ?Ý×CnstGrup???ÝÙnameStrn???
kEditClear CompStrn???VsblInt ???EncoInt ??nameStrn???
kEditClear typeInt ???defnStrn???a&Delete flagInt ???CInsGrup???0?ÝÚpltfInt ???langInt ???defnStrn???a&Delete EndGInt ?ÝÚCInsGrup???0?ÝÛpltfInt ???langInt ???defnStrn???a&Delete EndGInt ?ÝÛEndGInt ?ÝÙPadnPadn??

right-click the link and Save Link As

Got it … thanks guys, I’ll examine it tomorrow at work. At home at the moment, had a quick look at the code, etc but don’t have MySQL on home system. Looks fairly straight forward tho.