Re: Need to relate 2 SQL fields in an InfoPath 2007 form

Anson Hidajat — Fri, 02 Mar 2012 13:53:09 GMT

You can connect your IP form to the SQL database as a secondary connection. Then use filters in your form to find the manager name and then auopopulate email.

If your table is large, this may impact performance on the form. You can look into DBXL which has a web service that you can use to query a DB and allows for filtering very easily to limit the result set.

More info: http://www.qdabra.com/en/products/DBXL.aspx

Need to relate 2 SQL fields in an InfoPath 2007 form

jlgpsidev2010 — Fri, 24 Feb 2012 18:16:09 GMT

Hi, I am looking for some guidance and hope you can help.

I have created a Purchase Request form. Inside this form is a data connection to a SQL db that holds manager information. Two of the fields are Manager Name and Manager Email. When the Manager Name is selected I would like the manager email to be automatically populated with his/her email. Is this possible?

Jamie

SQL Database Integration

Re: Need to relate 2 SQL fields in an InfoPath 2007 form

Need to relate 2 SQL fields in an InfoPath 2007 form