I have a "project" InfoPath form that uses a Person/Group picker. I would like to be able to relate the people chosen in that form back to the project that they were chosen in. The primary problem is that the Person/Group picker fields always end up as semicolon delimited entries in a published column (as do any other "merged" fields that are published).
For example, I would like to use a data view web part to create a "drill down" or expandable list of all the projects. Each of these would then have the project members broken out. The user could click on "Wall Building" (the project name) and all assigned members would appear below.
Alternatively, I'd like to have a second data view web part that looks at the individual people and relates which projects they have been included in. The user would click on "Green, Bob" and see both "Wall Building" and "Leaf Raking" below his name.
Item Title: Wall Building
Assignees: Smith, John; Doe, Jane; Green, Bob
Item Title: Leaf Raking
Assignees: Public, John; Green, Bob; Murphy, Steven
Perhaps JQuery with a bunch of divs that are hidden until clicked could handle this. I could use CAML queries to pull the data into a content editor web part and parse the "Assignee" values into arrays...
Is there a better way to do this? An expandable / collapsable list of projects and all associated assignees perhaps using a data view web part with filters?