Thanks Steve, this has helped me a lot.

Kind Regards,

Jonathan

Aah ok. Table one cannot be changed as it's from a datasource. The primary key from this would be the Product Code.

Would the ProductType Number start over agin when there is a new product Group?

Sorry, but 1 more question. As you can tell im very new to this. Im getting an error message.

SELECT HQCUST + ' -' + HQDADD AS HQCFLD,

AIMPDTA.HQANALLA.*

FROM AIMPDTA.HQANALLA

This is...