https://www.infopathdev.com:443/forums/46.aspx For questions concerning issues in the integration of SharePoint and Microsoft InfoPath.enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/82811.aspxTue, 18 Sep 2012 20:40:36 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:82811SPUser0https://www.infopathdev.com:443/forums/thread/82811.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=46&PostID=82811I am currently using SP 2010 and Infopath 2010. Here is my case: I have three sharepoint lists and the relationship between them being GrandParent --> Parent --> Child. And the fields GrandParent {ID} = parent {grandParentRefID} Parent {ID } = Child {ParentRefID} In the Infopath form for the grandparent list, I need to show the parent and child records. I am able to get the parent+child records using data connections. The issue is with grouping the parent and child records. I need to filter child records to show like this : GrandParent Record: GPID Parent1 - Child 1 Child 2 Parent2 - Child 3 Child 4 I tried using current() to filter the child records but the current() becomes the value of the innermost repeating table's current row and not the parent current row. I really appreciate any help to group the records as I want. Right now, I get like this: GrandParent Record: GPID Parent1 - Child 1 Child 2 Child 3 Child 4 Parent2 - Child 1 Child 2 Child 3 Child 4