>Thanks for the reply Craig!
>
>Yeah, I knew I could make separate recordsets but I was hoping there was an easier way. I thought there was some way that you could say only update the one table and not the other when you do a delete.
I never use updateable ADO record sets that go back to multiple tables for the same reasons that I don't do this for local views. There are just too many problems to deal with ... one of which you've found.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer