MS InfoPath Form with 2 data connections.

See more:

C#

XML

C#4.0

SharePoint

InfoPath

I have created a SharePoint site and within it there is an InfoPath form that has several
fields. Within that form there are 4 text boxes that retrieve data from the Active Directory of
Windows Server 2008 R2.

I have created a data connection within that InforPath form to retrieve data like 'First
Name', 'Last Name', 'Job Title' & 'Department. Now I have created a SharePoint list that used to
store 'First Name', 'Last Name', 'Annual Leaves', 'Vocational Leaves' & 'Other Leaves'.

It means that there are 2 data connections within the MS InfoPath form one for Active Directory
data retrieval & one for the SharePoint list data retrieval.

All I want is now to view the contents in the InfoPath form as the following.

The Active Directory should retrieve the First Name, Last Name, Title, & Department.
The SharePoint list should view the Annual Leaves, Vocational Leaves & Other leaves
corresponding to the First Name & Last Name of the Active Directory was supplied.

All I want is to link the data from 2 data connections in the same InfoPath form. I can't figure
out the algorithm or any other method to solve that problem.

Can someone please give me some tip about this matter.

Thank You,
Chiranthaka