>I've removed all the rfi's attached to both those tables and tried again. No joy?! any more ideas?
Actually yes.
You could try deleting the record(s) in your view, then checking it with TABLEUPDATE(). Any error message poping up while you're doing these attempts, by the way?
Danijel