Hi,
I'm wanting to limit the select list in the detail form based on the value from the master form. This needs to be a dynamic action as I want this to change the value in the detail section without having to save the master form.
Example:
Master form has a number of items, one of these is the dept number (LOV). Once a value is selected in the master form, I want to limit the number of employees available to select in the detail form based on the master form selection.
This works ok if I save the master form, then the employee drop down list will be based on the saved deptno. I want to have this list dynamically populated after a change to the departno in the master form, without having to save the master record.
If the item was in the master section I would do this with a dynamic action, I've tried with a dynamic action to refresh the detail region, but this does not work.
I've create a sample master detail form that demonstrates what I'm trying to get working:
https://apex.oracle.com/pls/apex/f?p=71171:1:0:::::
Any advice/help would be appreciated.