This is probably a pretty dumb question and somewhere on the forum (I can't find it). I have a repeating table with a cascading listbox (let's use State, City, Street as an example).
My first problem is that let's say I choose California as the State then choose Los Angeles. I realize I made a mistake and actually met Massachusetts and Boston. If I go to state and change it to Massachusetts I get all the cities in Massachusetts plus Los Angeles. How can I get everything to "reset" when I change the State?
My second issue is when I have a repeating row. Whatever city I choose in the first row is always available in the subsequent rows for cities no matter if it should be there or not. Any help would be appreciated.