I've been evaluating InfoPath 2010 using sharepoint recently, and I want to see what the level effort would be to accomplish the following
1. Users would input field data in a repeating table
2. Click a button and have it take all records matching 'field1' and put that in a new infopath form file, then the values matching a different value in 'field1' and put that in a 2nd InfoPath form file
3. user could then submit each file individually
Is this difficult?
Can it be done using rules (doesn't look like it...) Is the custom code option too time consuming?
Can it be accomplished easily or should I focus on processing the file from the forms library once it's uploaded?
If anyone has done similar, or has some code examples, let me know, thanks!