Setting value of a query field - InfoPath Dev
in

InfoPath Dev

Setting value of a query field

Last post 05-05-2007 08:39 PM by Matt Faus. 1 replies.
Page 1 of 1 (2 items)
Sort Posts: Previous Next
  • 09-13-2006 08:33 AM

    Setting value of a query field

    I think the falls under the category of inconvenience.

    I have two tables with a structure as follows:

    +Table1
    Table1ID
    Table1Fields

    +Table2
    Table2ID
    Table2Fields

    On the main page, Table2 is a repeating section residing within Table1 (which is also repeating).

    The user runs a query that will return all entries in Table1 and Table2.

    I have a button located inside the Table2 repeating section that has one rule with several actions which are as follows:
    SetValue of Query Field Table1ID to current Table1ID
    SetValue of Query Field Table2ID to current Table2ID
    Query Main Connection
    SetValue of Query Field Table1ID to blank
    SetValue of Query Field Table2ID to blank

    These rules were supposed to isolate a specific record in the form and prepare the query fields for another query. While they do isolate a record, and set the Table2ID query field to blank, it does not set the Table1ID query field to blank.

    I have managed to work around this by using one line of code, however, it has greatly slowed down the performance of my form.

    I think this problem could be fixed by allowing the editing of the XPath in the "Field" field in the "Set a field's value" dialog box.

  • 05-05-2007 08:39 PM In reply to

    Re: Setting value of a query field

    Hi trufooser,

    I think it will be easier in this situation to run two seperate queries against the tables, and then link them yourself with XPath and conditional visibility.
    Matt Faus / Microsoft InfoPath MVP
    Qdabra® Software / 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.