Thanks all,

I seem to have figured it out. I did try recreating the issue in another database and could not reproduce the problem. It was only happening on...

Table B is a lookup table that has multiple columns but contains the ID column from table1 and table2.

Robert,

I figured this out a couple days ago and hadn't updated my post. You are correct in that the first error message wasn't getting logged but it took me...