>>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?

In Norway do you have an equivalent of the phrase "I'm so happy I could kiss you"? Well we do down here, and I am, so I could! Purely platonic of course...

Thanks a ton, must do some homework to find out why it was the view not the table that cracked it but for now...

Sarah