Thanks for the help guys...yu were right on the mark with the suggested code I didnt know i could do a join like that!!

I hadnt considered that I was changing the primary key, but have had a good look, and in this case, it wont have any adverse affects on the data

Thanks again!

Ben