>Hello!
>
>I have an ADO recordset that I create from two tables. If I delete a record in the recordset it deletes matching records in BOTH tables. I just want to delete the record in the first table not the second. I'm pretty sure there is a way to do this but I can't seem to find any info on it.
>
>AHWBGA!


Don't make an RS this way. Make an RS that is for one table only.