InfoPath Dev

Hello everyone, request urgent support.

I am from the HR field and I want to use InfoPath with SharePoint for tracking execution of identified Trainings.

I have a SHP list that comprises of all the trainings from various departments (LIST 1). Some of the columns are Sr. No., Training Topic, Department Code.

I have another SHP list that will receive entries of identified trainings for various employees (LIST 2). Each line item will be spread across the following columns: Employee Name, Training Topic, Department Code. This list, will initiate a workflow that assigns task to each trainer and so on...this workflow thing is working.

What am I looking for?

When I enter Department Code of the employee on InfoPath Form, it should generate the list of available training programs from LIST1 matching that department code. This list should give me a check box to select which all training programs are applicable. Once selected, I want to submit applicable training programs of this employee in LIST2; such that each training program is a separate line item so that the tasks can be assigned to respective trainers.

Hope there is a solution available to this....looking forward for support from the experts.

Thanks

 Hi there, sorry for the delay in response.

 In order to submit to your LIST2 from your InfoPath form, you will need to use CAML.  Here is a link to a tutorial that explains how to use CAML: http://www.infopathdev.com/blogs/matt/archive/2006/02/02/Add-SharePoint-List-Items-with-InfoPath.aspx

In order to generate the list of available training programs from LIST1, you will need to query LIST1.  First create a data connection to LIST1, then on the Department Code field add an action rule that will query LIST1 for items matching the value of that field:

(1) Set a field: DepartmentCodeQueryFieldInLIST1 = DepartmentCodeFieldInMainDataSource

(2) Query LIST1

(3) Display whatever data fields you want from LIST1 on your form

Hope that helps!