I have a simple launch page that includes two listbox controls. The 1st listbox is populated with a list of Parent Offices and the 2nd with Child offices. I have chained these listboxes together and both include the option to select . The chain appears to work in that when I run the launch page and select Parent Customer A from listbox 1 the 2nd listbox populates with all the Child Offices of Parent A. My issue is with the ALL that appears in the 2nd listbox. If I have selected Parent A from the 1st listbox and ALL from the 2nd my expectation is that this would return me ALL the child offices of Parent A. The actual behavior I am seeing is that this returns ALL children regardless of Parent as if this ALL in the 2nd listbox overrides the Parent selection. Is there some additional parameter I need to have selected to make the ALL in the 2nd listbox only apply to the specific children of the select Parent?

Bob

This message has been edited. Last edited by: bcook278,

Bob,

Without actually creating a launch page like yours and then testing it, I have a possible reason why you're seeing this behaviour. If "this returns ALL children regardless of Parent as if this ALL in the 2nd listbox overrides the Parent selection" is occurring in the fex that is launched by the launch page, it's perhaps because the two related selection criteria are in one WHERE and the "ALL" option (translated to "FOC_NONE") disables both selection criteria. Try two separate WHERE statements. This is a wild guess.

That would be my not-so-wild guess as well. I've answered that one MANY times for my users.

The resolution to your problem lies in the construction of your WHERE statement. Either the FOC_NONE issue has bitten you and you need to simplify your WHERE statement, or you've got your parameters switched up and are passing the child value to the parent selection.

[SOLVED] It was definately an issue with everything being within a single WHERE statement. Once I seperated this out everything was working as intended. Thanks for the assist.

Bob C

Nice to know the guess wasn't wild at all.