>Hi Naomi,
>
>They are related by having both Ordernum, Linenum, and Delnum.
>
>Regards,
>Sam
Sam,
I see that Cetin already gave you the solution. I was thinking along the same lines but a bit more complex of doing left join... Hopefully the new code gives you the desired result.
If it's not broken, fix it until it is.
My Blog