Repeating Data, Multi Choice Lists/Repeating Sections and Transmitting to SharePoint

Hi Experts,

I'm currently building a form, the intent is to collect capability requirements from various business units. Now there are approx. 35 potential capabilities, any given business unit may have a requirement for 5-10 capabilities. Capabilities also have dependent required fields (For example, how many hours will you need this capability for).  This form will submit to SharePoint where an analysis tool will look at the submitted data.

What I'm asking is rather than having a business unit submit 5-10 separate forms is there any Great Solution to have multi choice lists / repeating sections submit to SharePoint in a way does not require the data to be "cleaned" by an analysis engine.  Moreover, each capability should its own separate justification and approval / denial section for approvers. As I'm writing this, I guess what this boils down to is can you take a repeating group and have that create a separate "line item" in a SharePoint List without doing some pretty complex coding and developer-side manipulation of SharePoint views?
LVL 1
-PolakAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

-PolakAuthor Commented:
I can't edit my last paragraph because this question has been posted to more than 3 EE sections. Please read this edited version:

What I'm asking is rather than having a business unit submit 5-10 separate forms is there any Great Solution to have multi choice lists / repeating sections submit to SharePoint in a way does not require the data to be "cleaned" by an analysis engine.  As I'm writing this, I guess what this boils down to is can you take a repeating group and have that create a separate field/column in a SharePoint List without doing some pretty complex coding and developer-side manipulation of SharePoint views?
0
Clay FoxDirector of Business IntegrationCommented:
The challenge is to build a real application, with relational data, is tough in SharePoint since it is all flat lists.  There are some ways to relate lists and create some relationships.

Have you thought about using SQL so your data structure can be correct and you can have all of the relationships you want? You could use BCS but ideally web services to interact.  Qdabra.com has a product for this as well.

You can still have SharePoint / InfoPath client side, so the users do not really know, but you gain the benefits on storing, leveraging, and especially reporting on the information.

Just seen a lot of people struggle trying to build a sophisticated solution without the right materials. So you really want to understand the limitations and how that will impact the solution be for you spend too much time on it.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
-PolakAuthor Commented:
Your right, I should probably stop trying to massage SharePoint to do this without the proper tools.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
InfoPath

From novice to tech pro — start learning today.