Then THAT is the problem! It's been so long since I've used views. I saved a copy of the one using the View so that if I figured out why it wasn't working, I could re-use it. I've used SQL pass-through (SPT), but not much in the way of views and remote views. When I did use views, it was mostly for reporting with a parameter.
>You don't do an APPEND with a View. Could that have been your problem or were you just saying you needed to append a new record?