D
dayofthedave
I have a repeating table of list boxes where the options in list box B
are dependent on the selection from list box A. The cascade is achieved
just fine using an OnAfterChange script that runs a custom query on a
secondary data source...
var query = "SELECT [Foo] FROM [Bar] WHERE [ItemA] = " +
eventObj.Source.xml;
XDocument.DataAdapters['Bar'].Command = query;
XDocument.DataAdapters['Bar'].Query();
My only problem is that, when I have more than one row in my repeating
table, ALL of the B list box options are cascaded based on the
most-recently selected list box A option.
Does anyone know of a way to "lock in" the options for all B list
boxes, only allowing the options to change when the associated list box
A is changed?
BTW, I am running individual queries for each selection because I am
working with a very large data source... it takes way too long to load
the whole table once and just run filters on the data.
are dependent on the selection from list box A. The cascade is achieved
just fine using an OnAfterChange script that runs a custom query on a
secondary data source...
var query = "SELECT [Foo] FROM [Bar] WHERE [ItemA] = " +
eventObj.Source.xml;
XDocument.DataAdapters['Bar'].Command = query;
XDocument.DataAdapters['Bar'].Query();
My only problem is that, when I have more than one row in my repeating
table, ALL of the B list box options are cascaded based on the
most-recently selected list box A option.
Does anyone know of a way to "lock in" the options for all B list
boxes, only allowing the options to change when the associated list box
A is changed?
BTW, I am running individual queries for each selection because I am
working with a very large data source... it takes way too long to load
the whole table once and just run filters on the data.