I'm trying to create an incident management system for reporting, investigation, analysis and follow-up. The element that has stopped me in my tracks is the analysis module because I'm not understanding how to set up a cascading or hierarchical set of value lists. I've attached screenshots of the table relationships and of the fields for the analysis module, and a spreadsheet showing the values and fields of all of the tables. What I'm trying to achieve is:
a. Loss Action selection narrows Immediate Cause choices (the statistically likely ones)
b. Immediate Cause selection narrows to Basic Causes Category choices
c. Basic Cause Category selection returns applicable Basic Cause Detail
d. Basic Cause Detail, blah, blah, blah, Potential Corrective Action Category
e. PCAC returns PCA Detail
f. Lather, rinse, repeat.
The tables have already been set up so the values are carriage return separated. Having gone over the Adventures in CVL's I think it makes more sense to do ESQL, but I'm not understanding how to set up the query or set up a value list driven by the query.
Thoughts or ideas? Thanks in advance,