Autmatically populate expression box based on selection from dropdown - InfoPath Dev
in

InfoPath Dev

Autmatically populate expression box based on selection from dropdown

Last post 05-26-2009 10:31 PM by Patrick Halstead. 1 replies.
Page 1 of 1 (2 items)
Sort Posts: Previous Next
  • 05-26-2009 06:52 PM

    Autmatically populate expression box based on selection from dropdown

    Hi,

     

    I have a dropdown in my infopath form that queries the 2nd column in a SQL table. I would like to have the next field automatically populate with the value of the third column. Is this possible?

     Thanks

  • 05-26-2009 10:31 PM In reply to

    Re: Autmatically populate expression box based on selection from dropdown

    If you download all contents of both columns, you can use filters to do this. It's easy. However, there are performance ramifications to downloading all data from both columns.

    I recommend Qdabra's Web service which allows parameterized query. You can query just one column and then use the value to programmatically query another column. Great taste and less filling.

    Patrick Halstead
    Project Manager at Qdabra
Page 1 of 1 (2 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.