>>>Thank you. I will have to figure a way to make sure that only one record is selected.
>>>
>>See my initial suggestion with TOP 1 clause.
>
>I did try it but it gave me more than one child record. But I will revisit it. Thank you.
I'll take a closer look later tonight.
If it's not broken, fix it until it is.
My Blog 
