Thanks for your continued help.
I was having an issue with old data from the third party remote database still hanging about in the database even though I had removed it from third party database. This seems to however have been because there was no null value. So it looks like your suggestion may be working! 🙂