I have 2 SharePoint lists that have a 1 (list 1) to many (list 2) relationship. I have 1 of the SharePoint lists nested inside the other list in a repeating table. The value that both lists have in common are their titles. In this case, the client wants to print off every instance and the basic information of list 1, and the last field contains the other table's information (list 2) that displays the rest of the items that relate to the title. The client says that I cannot use SQL at all, and I can only use SharePoint lists. I have tried conditional formatting to hide the control when @Title(list1) does not equal @Title(list2). When I did this, it did not show any values @ all because it hid them all. I have read the other posts, but they all deal with SQL.
This works if I know what the title is, but in this instance, I cannot.
I appreciate any suggestions?
Thanks