Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2010

    Unanswered: Dependent Dropdown Menus - Application Inquiry


    I was wondering what programs out there would be able to do the following:

    I have several lists of things and would like to be able to have these display as dropdown menus which are dependent on the dropdown choices that precede. For instance, in dropdown menu #1, I can select a PROBLEM. In dropdown #2, I am presented only with SOLUTIONS for that PROBLEM chosen in dropdwn #1. Then, in dropdown #3, I am presented with PRODUCTS that match to the PROBLEM/SOLUTION combination. Thus, the choices in dropdown #3 are dependent on the combination of choices in #1 and #2. There are multiple SOLUTIONS to the same PROBLEM and multiple PRODUCTS to the same PROBLEM/SOLUTION combination.

    I know this can be done using Data Validation in Excel as well as some SQL programming. However, I'm wondering if there are programs out there that would do this using a friendly GUI limiting or getting rid of the need for any programming.

    I've done searches for 'decision tree software' and 'IF/THEN software' to no avail. Any suggestions for actual programs or better search keywords is greatly appreciated!

    (I apologize if this topic is in the wrong thread.)

    Thank you,

  2. #2
    Join Date
    Jul 2003
    San Antonio, TX
    Look into SSRS, but the dependency you describe will still have to be coded.
    "The data in a record depends on the Key to the record, the Whole Key, and
    nothing but the Key, so help me Codd."

  3. #3
    Join Date
    Mar 2010
    Thank you, rdjabarov. I will definitely look into this. Will the coding of the dependencies need to be programmed using JOIN commands in SQL?

    I'm wondering if there's an easier non-programming way as it seems quite simple to tell a program that the choices in dropdown #3 should depend on the choices made in #2 and #1. Perhaps it's wishful thinking.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts