I 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 ...