Hi Folks:
I have an interactive grid where the users may have to set multiple rows to the same value. I created items to contain the values they want it set to. Then the thought is they would just clck on the row and it would auto-fill. The idea being they may have 100 different chemicals on their account and maybe they want to randomly select 10 to transfer to a different user. Below are the settings I have. (in case it is confusing there are two ig grids also in the subregion. They can be ignored).
1. Item that the user will initially put the name into (person transfering to:) P14_TRANSFEREE (This item is above the IG on the same page)
2. When the user clicks on the NEW_ACCOUNTABLE_OFFICER item (which is part of the IG)
3. Dynamic action set to execute on click. First it clears anything there. Then it should fill the field with the value from P14_TRANSFEREE.
Below are the settings I have. The field is cleared ok, but the substitution variable is not inserted into the NEW_ACCOUNTABLE_FIELD. I tried using &P14_TRANSFEREE and also tried :P14_TRANSFEREE as a plsql function body and also plsql expresssion.
I think I'm on the right track but am doing something wrong. I hope I gave enough info. Thanks for any help.... Matthew
