Bret,
>
> ...Now I require data from Table two to be displayed in the Summary band of the report....
>
How about employing a method or function for that (at least to select the correct record of the second table)? You might need to cut the relation as You might be eof() in Table one at that time. Or prepare the data so they already are in one cursor.