I have to edit or delete a record of the side "one" of a join.

DAO simply edits or deletes the record of the main table. With ADO, i get an error ("no information for key column"). Can I set an option, or something like that, to let ADO knows the main table ?

The only workaround I found is to find that record on another recordset (just the main table); edit or delete it; refresh the join recordset. I'd rather do on the join recordset itself.

Many thanks in advance.

Which database are you using ? What is your original query that creates the recordset ?

I have this problem with Access 2000 and with SQL Server. I'm pretty sure it's an option to set on the ADO recordset...

The join is a classical inner join between two tables (main/detail).

Thanks...