Two different queries to the SQL database in InfoPath 2003 - InfoPath Dev
in

InfoPath Dev

Two different queries to the SQL database in InfoPath 2003

Last post 03-31-2008 08:48 AM by Clay Fox. 1 replies.
Page 1 of 1 (2 items)
Sort Posts: Previous Next

  • 03-31-2008 05:25 AM

    • stuck
    • Top 150 Contributor
    • Joined on 03-26-2008
    • Posts 74

    Two different queries to the SQL database in InfoPath 2003

    Reply Contact

    Does anyone know if it's possible to run 2 separate queries in InfoPath 2003 to a SQL Server 2000 database?

    I can get the first one up and running but then I want a second query which queries a different table. So I change my main connection to add a new table, but it will ask for a relationship. These two tables are not necessary related. So how would you add new table to query it?

     

  • 03-31-2008 08:48 AM In reply to

    Re: Two different queries to the SQL database in InfoPath 2003

    Mark as Answer
    Reply Contact

    The key is web services.

    The basic database connectivity in InfoPath has limitations as you have encountered.

    InfoPath was designed to use web services and they give you all of the functionality.

    You can both query and submit to multiple tables.

    Send me an email and I could show you some examples.

    Clay Fox / Microsoft InfoPath MVP
Page 1 of 1 (2 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.