Delete operation

Hi ,
I have a MSHFlexGrid which displays data that is a product of
several joined tables.
The joining product is assigned into a recordset & this recordset is
the datasource for the MSHFlexGrid .(after the assignment I destroy the
recordset).

Whenever I query \ add \show all record(s) I create a new recordset
,execute the operation and again , assign the recordset to be the data
source of the MSHFlexGrid .

All of the above works fine until I'm trying to delete -
If I execute delete operation any attempt to show all of the records
fails and the recordset retrieve only minor part of them.
The cursor I use is of type adOpenKeyset,
and locking type is adLockOptimistic.

I'd be grateful if someone could help me out with this problem
Thanks in advance
Sagiv