>On somewhat related and somewhat unrelated subject. Have you ever had INSTEAD OF UPDATE trigger that updates multiple tables? Any problems with that?
No, unfortunately I never used it other than in the case I mentioned but it did nothing, as I was only interested in the INSERT, furthermore, I think that I even got read of the FK, as it was not important anyways, I will need to check that.
Sorry I cannot be of more help here.
"The five senses obstruct or deform the apprehension of reality."
Jorge L. Borges?
"Premature optimization is the root of all evil in programming."
Donald Knuth, repeating C. A. R. Hoare
"To die for a religion is easier than to live it absolutely"
Jorge L. Borges