Multiple-choice from another field

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered

I have a simple bug tracker that I want to add some structure to based on the actual functionality available in the web applications that I am working with. WebApp1 has different features than WebApp2 and as I add a new bug I want to be able to use a chain of Text - Multiple Choice fields that references a separate table that has the data which describes the WebApps.

Table 1 = Bugs and Table 2 = App Functions

While adding a bug I want to be able to be able to select which WebApp the bug is in, based on that selection a limited list of features specific to that WebApp will be displayed (data drawn from App Functions table) that then allows me to select the feature that then limits my choices of the Object (data drawn from App Functions table) linked to WebApp>Feature with that selection limiting me to options for Action (data drawn from App Functions table) and so on.

Make sense?

Photo of Owen


  • 0 Points

Posted 3 years ago

  • 0
  • 1
Photo of Xavier Fan

Xavier Fan, Champion

  • 410 Points 250 badge 2x thumb
If I understand what you're saying - I'd suggest you first build your "chain of multiple choice dropdowns" as a nested hierarchy of tables, with the base table relationships as follows:

1 WebApp has many Features

1 Feature has many Objects

1 Object has many Actions


Then you'd need to also relate these table to the "grandparent" table, or you can relate all of them to the parent "WebApp" table.


1 WebApp has many Objects

1 WebApp has many Actions

Then you can set up Conditional Dropdowns - using "Related WebApp" to figure out which of the "child" records should be shown based on the selection.

I'd say first get one set of conditional dropdowns working (say WebApp / Features / Objects) - and then decide whether this will work for your use case.

Here's the online help on Conditional Dropdowns: