I am trying to find a way to filter a DVWP from values on another list.
Both lists are going to be inside an iframe and the first list (Orders) is filtered using querystring, everything works great and it returns multiple values no problem.
The problems is filtering the second list (Invoices). It is actually a SQL datasource for invoices, there can be multiple invoices per order.
I tried using a connection to get filter values and this works but will only use the first row from the Orders list.
Order list has 3 orders: 123, 456, 789
Invoice list will only show invoices for order 123, and will ignore the others, I am trying to show all invoices related to any order number in the list
I cannot seem to find a way to make it look through all the rows on the order list and use those as filters, is there any way to use each row to filter the other list?