InfoPath Dev

Hi,

I need some guidance to select best appoach to implement the current requirement in my office of collecting skills data for different Service Areas,

Requirement is as below

Keeping User experience very simple.

1. Need to collect SKills Data from different Knowledge Communities that is Service lines. Create 6 different forms for 6 Kcs.

2. There will be some skills shared across KCs like some Skills will be common in some forms.

3. Need to pull this data to create views on SharePoint site based on Skills Main Categories and Sub categories.

4. Creating Views based on Common/Shared skills from different KCs.

I will really apprciate if some one can guide me to chose the storage place for data for this requirement.

I am thinking of using InfoPath for creating forms but I am not able to decide the storage, shall it be SQL server or SharePoint 2010 List.

What will best suit the requirement considering keeping User experience simple and having quick response time while fetching the data back in to the views.

 Thanks a ton in advance.

Madhura

SharePoint lists are great because they are easy to set up and pull in data into the InfoPath form.  This is all available to you out of the box and is relatively simple to implement as well.  For each dropdown or list you need to import as choices into your form, you will need to create a SP list for.

If you require many records (eg. 1000+), you might consider SQL since it will scale much better than SharePoint will.  If that is the case, then you should consider looking into DBXL as a tool to help you manage your InfoPath forms in SQL.  Visit qdabra.com for more details and to download a trial if you are interested.  Good luck!