I want to select multiple names from the Mgr_Name field and select the same names in the Mgr_Name2 field in another chart via a trigger or any another method. I can get it to work with only one name selected, but it wont work if I select multiple names.
Here is what I have done:
Created a variable vName using the GetFieldSelections(mgr_Name)
Then I created a field event trigger on the mgr_Name 'On select" -> Select in field (Action)-> Mgr_Name2 (field) -> vName (search string)
Thanks for the help!
Thanks for the help. it worked after I put the code you gave GetFieldSelections(Mgr_Name,'"|"',100) & '")' in both the 'select in field' & ' on change' trigger.
Dear Ashwin, dear All,
I downloaded the file Mayil posted and indeed it is not working as expected.
I input the GetFieldSelections(Mgr_Name,'"|"',100) & '")' in both the 'select in field' & ' on change' trigger.
as indicated by you Ashwin and still indeed not working.
Could you please share a copy of the working file?
I also am facing a same issue and I need a solution !
thank you so much!