The title might not be very accurate to this, but I was struggling to find the right words. Here's the situation.
I've got a list called Labs with a person/group column that defines the data owner. I've got a Requests list from which one of the fields is a look up column to my Labs LabID column. I'm trying to build a DVWP that shows all the items from the requests list where the data owner is the current user. In SQL it'd be something like:
select * from labs where labid in (select labid from labs where data owner = 'user')
What I'm struggling with is how to set this up in a DVWP. I can't simply use the Created by person on my Requests list becasue requests can be input by different people. The idea is to allow a lab/data owner to see everything that has been submitted for all of their labs.
I'm wondering if it can be achieved with some sort of advanced filter or with specific CAML queries on the 2 data sources.