locked
Query data in a repeating table. Using combo box. RRS feed

  • Question

  • Hello! I have a doubt that can be a doubt other people, or even already is.

    My doubt is the following:
    I have a repeating table with two fields, one field is combo box or drop-down list, the other field is text.

    In the combo box or drop-down list has the reference data with an external list to the field, this reference will call "person", choosing the "person" to play one of this date in the second field, but to open the node repetition, he preeche altomaticamente value with the value of field2 with the first row of the repeating table of  field2.

    Thank !

    Monday, May 6, 2013 2:02 PM

Answers

  • Hi Breno,

    The new field should be blank when add a new row to the repeating table, could you please recheck the following step?

    1. Suppose this is my external list: Title, ID.
    2. Add repeating table in InfoPath Form with these 2 fields: field1 (combo box, get data from ID field of external list), field2.
    3. Then we can use following 2 ways to set associated Title to field2.
      1) Set default value to field2: Title[ID = current()/../field1]
         Get Title field from external list data source with filter: ID = field1 in Main data source.
      2) Set value to field2 from rule and the action rule is added to field1.
       Set field2 = Title[ID = field1]
    4. Done. If the problem persists, please check if the field1 and field2 are both created under the repeating table group. Or any other rule has an option to set value to field2.

    Thanks & Regards,
    Emir


    Emir Liu
    TechNet Community Support

    • Marked as answer by Emir Liu Friday, May 17, 2013 6:24 AM
    Tuesday, May 7, 2013 8:26 AM