Hi,
I am trying to get Multiple Values in my "Activities" _Multiple-Selection_ look up field pre-selected - based on the value choosen in the "Role" look up _Dropdown_
Example:
Chose ValueA in the "Role" Dropdown and Values One, Two will be selected in the "Activities" _Multiple-Selection_ lookup field.
Chose ValueB in the "Role" Dropdown and Values three, four will be selected in the "Activities" _Multiple-Selection_ lookup field.
The values which should be selected are in the list where all Values from the Role dropdown are listed in coulm "Role" the value for the dropdown and in column "Activity"
Have a look at the attachment
I use Infopath 2013 with a Sharepoint 2010 Server
Thanks a lot,
Rene