Parent-Child relationship retrieves only first row of data - InfoPath Dev
in

InfoPath Dev

Parent-Child relationship retrieves only first row of data

Last post 08-27-2014 11:28 AM by Hilary Stoupa. 1 replies.
Page 1 of 1 (2 items)
Sort Posts: Previous Next
  • 08-25-2014 12:12 PM

    • ITGirl
    • Not Ranked
    • Joined on 02-03-2009
    • Posts 2

    Parent-Child relationship retrieves only first row of data

    Hello, I have two SharePoint lists: Job (Parent) and Job Items (Child); there is a one to many relationship between the Job and the Job Items. I am trying to populate a repeating table with info from the Child list based on the Job Number of the parent. I am using rules on my repeating table to set the value of the fields based on a filter that checks if the Job number of the parent equals the Job number of the Child. The problem that I have is that i get only the first row back. How can I get all the rows of the Child table when they all match a Job Number and populate the repeating table? Thank you
  • 08-27-2014 11:28 AM In reply to

    Re: Parent-Child relationship retrieves only first row of data

    The problem is that InfoPath doesn't offer any way out of the box to add rows to a repeating table. You either need to use code (or qRules) - if you don't need to save the data, you could just display the relevant rows from your secondary data source?

    Hilary Stoupa

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