I am trying to figure out how I can create a dynamic drop list for data entry on a data view.
For example:
An Entity gets flagged for the creation of an incident.
Once flagged, various input information is required - namely: Incident Type, Incident Category and Incident Sub Category.
A user is required to capture this information, but ideally I do not want them to have to scroll through the full list of options.
so.... if there is the following relationship:
Incident sub-category - Incident category - Incident type
Then it should be honored when completing the data entry.
The scenario should be as follows:

then:

where the "Greater than 5000" and "Less than 5000" is a child of "Shortage"
and then:

where "Lost", "Stolen" and "Correction" are children of Incident category.
Is this doable?
Thanks in advance.