Populating a field in a table from a secondary data source - InfoPath Dev
in

InfoPath Dev

Use our Google Custom Search for best site search results.

Populating a field in a table from a secondary data source

Last post 10-05-2007 11:42 AM by RLPopeIII. 5 replies.
Page 1 of 1 (6 items)
Sort Posts: Previous Next
  • 09-26-2007 06:39 AM

    Populating a field in a table from a secondary data source

    I have searched and not found exactly what I am looking for:

     

    I have an xml file with student data that I am using as a secondary data source.  I have a repeating table that I would like to pre-populate the first field with the students' names.  Is there a way to do this wth out code? 

     

    Thanks,

     

     

    Ren

  • 09-26-2007 07:48 AM In reply to

    Re: Populating a field in a table from a secondary data source

    Hello

    Is your field a drop down and want to show all the names from the XML into the Drop down?

    Kalyan G Reddy
    Infopath MVP 2007 and 2008
  • 09-26-2007 09:57 AM In reply to

    Re: Populating a field in a table from a secondary data source

    Kalyan,

     Thank you for the quick reply.

    No, they are text boxes.  For example, my secondary source has 4 students in a repeating table.  I need to create a new table with the first element in each row filled in with the students' name.

     Once again,

     

    Thank you,

     

    Ren 

  • 10-02-2007 11:03 PM In reply to

    Re: Populating a field in a table from a secondary data source

    Hi Ren,

    I am afraid to copy a repeating table (or random number of rows of data) from secondary data source to another DOM will require code.

    Regards, 

    Stephanie

     

    Stephanie Cantwell / Test Manager
    Qdabra® Software / Streamline data gathering to turn process into knowledge

  • 10-04-2007 11:43 PM In reply to

    Re: Populating a field in a table from a secondary data source

    Ren

    It is a limit of the secondary data source that it cannot be used in this way.  It is only by making the data source the primary data source that such a scenario could be achieved, unless you code the behaviour.

    Cheers Adam

    Adam Harding
    Wales
    UK
  • 10-05-2007 11:42 AM In reply to

    Re: Populating a field in a table from a secondary data source

    Stephanie Cantwell:

    I am afraid to copy a repeating table (or random number of rows of data) from secondary data source to another DOM will require code.

     Stephanie,

    Thank you.  I have been trying to code this, but the Object model help and examples are pretty thin.  If the table in my main data source is:

    <AttendanceTable ClassSection="English 225">
         <StudentName/>
         <Attended/>
    </AttendanceTable>

    and my secondary data source is:

    <StudentRecords>
       <StudentName/>
       <CurrentClasses>
          <Class/>
       </CurrentClasss>
    </StudentRecords>

     

    What is the objects/methods:

    1. To get the the student name from the student record where class the class = English 225
    2. Populate the student name field for each row in the Attendance table

    Thank you,

     

    Ren

Page 1 of 1 (6 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.