It's 2 address tables that are being concatenated thats the problem..
What I am expecting to happen is:
Load from Client = 1st entry created with nothing related
Load from Address = 1st entry from before now associated with 2 new address rows
It all works fine with the tables are not concatenated or joined. But as soon as I join or concatenate then I get this strange issue that I dont see with other data.