Excel ListBox
Hello there,
I'm working in a project where I need to use two list boxes to fill a form with selected data. It goes something like this:
I have a db with Company, Product and the product's specifications. So, for example, I have:
Company 1 - Product 1 - Specifications 1
Company 1 - Product 2 - Specifications 2
...
Company 2 - Product 1 - Specifications 1
And it goes on like this.
What I need is to create a list box containing the companies and a second list box containing the products. The real magic is, when I select the company in the first list box the second one is filtered to only products of the selected company and only then I select the product that I want and it fills the form.
Can someone help me with this task?
Cheers.
|