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