Brand new to InfoPath 2013 with limited experience with Access. As subject says. I have an Access DB and I'm developing a form for my team to use to input data. I would like the form to pull from my Access DB a list of the team member's names which I have in a table (TEAM_MEMBERS), provide a MSLP for one of the team members to use and select from the list of team members, then populate who they selected in another table (SURVEY_EVENT) as a single, semi-colon seperated, value of who was selected in the same Access DB once they submit the form.
As it stands now, I have it working to the point where when I preview the form and select from the MSLP, only 1 of the values populates into the SURVEY_EVENT table. Trying to figure out what rule or logic needs to be used in order for all of the selections in the MPLS to populate the SURVEY_EVENT table row, not just 1 of the selections.
Sifting through the other threads on the forum, I pieced together the following rule into the MPLS control.
eval(eval(., 'concat(., ";")'), "..")
What am I missing? Any help is greatly appreciated!!