Hi Allen

Thanks for all your help. I'm due in a meeting now but will try the script tomorrow.

Cheers and best wishes,

Jon

Thanks. The other values are the same for every record so I've done a select * for the communications table and copied over the values for the other records that...

Thanks Allen. I'm sorry if I'm explaining things really badly. I'll just try once more (maybe it's not even possible in SQL, I'm not sure).

To do what I want to...

Thanks Allen.

If this means that I have to insert a column into the database then I won't be able to do this. We receive frequent upgrades from the database supplier...

Yes, each address has a different address_number so it is unique to that particular record.

Thanks,

Jon

Hi Allen

Thanks for your reply. I'm not 100% sure that I need to use a .csv file but thought it might be one way around my problem.

I am trying...