Message Preview - Capture data from repeating table to a database
I am trying to get around there being no multi-select dropdown control. I have searched and saw the blog:
http://blogs.msdn.com/infopath/archive/2004/04/01/106039.aspx. I also downloaded the Repeating Cascading Lists of Cascading Lists, v1.0 from Infopathdev.com which is exactly what I want it to look like my only question is does anyone know how to populate a database table with ALL the results of the repeating table?
My first drop-down is Service Area with 4 options. My second drop-down is Project Type based on the Service Area selected. My third drop-down is Technical Discipline based on the Service Area selected. My last drop-down is Service Performed based on the Service Area selected. Project type, Technical Discipline and service performed all have anywhere from 9 - 30 options based on the Service Area selected.
The repeating cascading lists of cascading lists works great but when I set the repeating field to connect to my database table I only get the last entry, not all the multi selections.
Can anyone help?