S
Skeletor
Hi all.
I have a database that has different tables for various product lines, etc.
For example, I have different sales categories, different suppliers and
different product lines. I would like a series of combo boxes to display data
based on the selection in the previous combo box.
For example, The first would be Sales Category. If we selected "Intrusion",
then the second combo box would display the list of suppliers that distribute
this product line. If we selected, "Bosch", then the third combo box would
drill down to the product range of that supplier. If we choose "Panels", then
the next combo box would display the list of panels. Upon selecting a panel
the final addittion would be the corresponding price of that panel in a text
box.
Can this be done? Or is there a better way?
Thankyou
Mike
I have a database that has different tables for various product lines, etc.
For example, I have different sales categories, different suppliers and
different product lines. I would like a series of combo boxes to display data
based on the selection in the previous combo box.
For example, The first would be Sales Category. If we selected "Intrusion",
then the second combo box would display the list of suppliers that distribute
this product line. If we selected, "Bosch", then the third combo box would
drill down to the product range of that supplier. If we choose "Panels", then
the next combo box would display the list of panels. Upon selecting a panel
the final addittion would be the corresponding price of that panel in a text
box.
Can this be done? Or is there a better way?
Thankyou
Mike