I don't think that it is possible, given straight table joins. CR does not read other rows of data.
2 solutions come to mind.
1) Create a sub report that runs at the start of the report to return a shared delimited stringvar of all the ids in the other table. Use this delimited string to see if the record you are looking at is in the string
2) Create a sub report to run just for the item in question and see if it is there.
From a performance point of view, the first option is better as you only hit the database 1 additional time, and not a whole lot more.
HTH
IP Logged
