[Originally posted by Harry]
I have bound a recordset to the MS data grid. The recordset joins the table I want to maintain to 2 other tables. The 2 other tables are joined into this recordset only for getting a description of a code.
When the user presses the delete key, the 2 other table records are getting deleted also.
The only solution I can think of is to handle the delete key manually, delete the row from the table and requery the recordset after each delete.