This may be pushing the Infopath limits (I know it is pushing the limits of my feeble brain). I am creating a SharePoint list form with the following relevant fields:
Main:
SharePointListItem_RW
-SoftSkill
-Value
-Links
-Value
Secondary:
SharePointListItem_RW
-qry
-URL
-Topic
-Type
On my form, I have the SoftSkill as a multi-select which uses external data source: Secondary with qry as the value and Topic is as the Display.
I also created another multi-select (let's call this multi-select B) for the Links which uses external data source: Secondary with URL as the value and display which is filtered where Main:SoftSkill\Value = Secondary:\qry
What I would love to do is have a repeating section on my form that lists each unique Type from my Secondary source and multi-select B's which only show that values from that Type (like a Group By)
So something like this:
TypeA
-Multi-select filtered from Main:SoftSkills\Value and TypeA
-------------------------------
TypeB
-Multi-select filtered from Main:SoftSkills\Value and TypeB
-------------------------------
TypeC
etc.
I can't add the multiselect to the repeating section so I am looking for another way to attack this.
Any assistance is greatly appreciated.