Hello John and thank you for replying!

I got as far as your suggested statement all by myself :)

However, the result was that the ccustcode field in every record in subcust gets the ccustcode code from the very first record in the customer table.

I must admit, I cannot see why this would be but that's what I am getting.

Thank you once again.