Hi everyone,

much belated thanks for all your help on this.

I tried various things but the approach that worked for me was "update the field to NULL, delete the record from the other table, and then delete the original record."
Post reply
Cheers,
Eamon