Need to relate 2 SQL fields in an InfoPath 2007 form - InfoPath Dev
in

InfoPath Dev

Need to relate 2 SQL fields in an InfoPath 2007 form

Last post 03-02-2012 05:53 AM by Anson Hidajat. 1 replies.
Page 1 of 1 (2 items)
Sort Posts: Previous Next

  • 02-24-2012 10:16 AM

    Need to relate 2 SQL fields in an InfoPath 2007 form

    Reply Contact

    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

  • 03-02-2012 05:53 AM In reply to

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

    Mark as Answer
    Reply Contact

    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

    Anson Hidajat
    Qdabra® Software/ InfoPathDev.com
    The InfoPath Experts – Streamline data gathering to turn process into knowledge.™
Page 1 of 1 (2 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.