Say I have a drop down list of Names, and a list box of Employee ID Numbers that are Chained together.

When I select an Employee Name, the List box of employee ID Numbers changes to only have the Employee ID for the Name I pick, which is Great! The only problem is, we would like to have the ability to pick "ALL" as well, but when we check the 'Add "ALL" Option' box in the texbox's properties, the Employee ID # isn't picked by default, so the user has to go over and click again to pick the ID # because the ALL option is selected.

Is it possible to change this?

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

That's the way chaining works. The only time anything will happen (modify contents, select values, etc.) in the EmpID# box is when you select a value in the Names box.

The "ALL" option is not a value. Under the covers, it is using FOC_NONE which in essence means "ignore this line of code". So if it's ignored, nothing happens in the chained box. Also, if you select "ALL" in the Names box, what would you expect should be selected in the EmpID# box? "ALL" is not related in any way to a value in EmpId so it would not know what to select in any case.

The way around it is to use your own Javascript to make it do what you need instead of using the default chaining functionality.

I'd add another way to do this. That is to use a fex to populate this. Darin sugessted a JavaScript - which is one way of doing it. But, then again, I'd rather do it in a fex. I'd go with whatever you are more with. The fex will require some logic to remove the "ALL" option if that's what you desire. I'd also use comboboxes for both.

Can you provide a sample fex from the empdata file?