>Jim,
>
>A little bit faster , it takes 5 minutes.
>
>Regards,
>Paul

Make sure you have indexes on the items in the LOCATE command.

Your first code was scanning through the entire child table regardless of finding a match or not.