Multiple Dynamic Listboxes

<i><b>Originally posted by : Arbil (ricky@rickysantos.com)</b></i><br />I have 4 listboxes which gets its value from a database with multiple tables.<br /><br />Upon loading, the 4 dropdown listbox will populate depending on their query statement. This <br /><br />is their initial value and it looks up to table1.<br /><br />Here's the flow of the 4 listboxes:<br /><br />Sales Area---> Sales Office---> Sales District---> Sales Group<br /><br />This flow is according to their level; Sales Group is the last level.<br /><br />If I choose a Sales Area, the 2nd box (Sales Office) will then display all Sales Offices <br /><br />under the chosen Sales Area (this will look up to table2). The page may Refresh on ONCHANGE <br /><br />event but the first box should still display the selected Sales Area and the 2nd box which <br /><br />now contains the list of Sales Offices based on the selected Sales Area.<br /><br />Now if I choose a Sales Office, the 3rd box will display all Sales District of the selected <br /><br />Sales Office (look up again in table2) and still displaying the selected items in the 1st <br /><br />and 2nd listboxes. <br /><br />I've tried several work arounds in this but was not successful enough. I can populate <br /><br />listboxes but dont know what do next once I select from any listbox.<br /><br />Note: There's no unique field between the tables I'm using such as ID's, etc. I just made a <br /><br />Selection from another table based on the selected item from the first table.<br /><br />If you know some site which uses this kind of dynamic listbox selection or have some idea or <br /><br />code, please help me I'll be very thankful.