On my form I have a listbox that I have linked to my suppliers table in my sql database. I want to create a second listbox (linked to another table - supplierlocations) that will pop up beside the first if a user clicks on a supplier that has more than one location/branch. Sort of like when you click on all programs on the computer and the additional programs pop up out the side to be selected.
I can create the listbox etc and bind it, I will probably use the visible property to have it appear when required, but what Im not sure about is how do I code the items (suppliers) in the first listbox (listbox1) to look through the second table (supplierlocations) and if the supplier has more than one location open the second listbox for the user to make their selection.
Thanks for any help on this, Diane