I think that will be what I end of doing, I was hoping that this could be done with just a table and a report without getting too much code involved.

>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.