I've been playing with Phil C's very helpful Conditional Value List file, Adventure 1 CVL, that I learned about through here: CVL with values based on only one table, problems but try as I might, I'm flat-out being dense with trying to get the Hierarchical Conditional Value List example to work with same-table values (as discussed in the linked thread) so I'm hoping either you, Phil, or someone else can simplify the answer further so I can grok it.
A simple setup:
Two tables, LANDING_PAGE and STANDARD_INDICATOR; LANDING_PAGE has a switchboard with two value global fields, g_Program and g_Subject, which is where users will choose the values that will in turn, fire a script to find appropriate records. It's these two fields where the value lists will appear.
_kpln is a primary key and _kfln is a foreign key.
STANDARD_INDICATOR stores the data where it has two fields, Program__lxt and Subject_Parent__lxt. Program__lxt is the "parent" in that it stores only two values, Elementary and Secondary. Subject_Parent__lxt stores about ten different