InfoPath Dev

Hi
I have a form that requires the users to enter details for both the approver and requester of the form.
To make things easier for staff I decided to create a web service that gets all the relevant details from AD.

Firstly i have tried creating an asp.net page (to be viewed in custom task pane) to allow a search to be done of AD.
The resulting search is returned to a datagrid due to possible multiples being returned. The user then clicks the person they are after in the datagrid to pass the data back to InfoPath and this is where i start bashing my head against walls because i just coulnd't figure it out (havent given up on the idea yet).

second i tried to use a secondary data connection in my form with a repeating table (as multiple usernames could be returned) and query to my web service. the user can do a search of AD and this works nicely.
The user should then be able to select one of the lines in the repeating table and populate the necessary fields in the form but i cant figure out how to pass the data from the relevant row in the repeating table into the matching fields in the rest of the form.

am i on the right track or should i tackle this in another way?
any advice would be greatly appreciated.

cheers

Horace

Hi Horace and welcome to our forum!
We sell a Web service for $19.95 USD that does what you want. How much are you paying yourself an hour? :)http://www.qdabra.com/proddetail.asp?prod=QADWS

Thanks Patrick but i have already written the web service to query AD
My problem is that i cant find out how to use it for multiple queries as required in my form

Hi Horace,
You can just add a data connection on your form and query it. If you need to do multiple queries, create a rule with multiple actions. Good luck!