delete record from select query and he is still in table

D

Dejan

I create SELECT qry from 4 tables (relations beetween tables is set to
CASCADE DELETE). When start qry and delete one record from datasheet view,
that record desapear from qry, but he is still in table. When i run qry
second time i dont see that record, like he is deleted, but he is still in
table..

Can anybody help me!

Thanks and sry for my language...
 
S

Steve Schapel

Dejan,

Well, it depends on how the query is set up. Sounds like the deletion
is happening to one of the "downstream" tables.

But anyway, if you have Cascade Detetes enabled for the relationships,
you should only need to delete the record directly from the parent
table, and the related records will be deleted without the need of
trying to do it in a query involving all 4 tables.
 
Top